$join public property
How to join with other tables. Each array element represents the specification of one join which has the following structure: [$joinType, $tableName, $joinCondition]
For example, [
['INNER JOIN', 'user', 'user.id = author_id'],
['LEFT JOIN', 'team', 'team.id = team_id'],
]
public array $join = null