How to do leftJoin() with two tables in yii2?

Question

MySQL

Here is a working query in sql:

SELECT * FROM `client` 
LEFT JOIN `user` ON `client`.`client_id` = `user`.`id`
LEFT JOIN `company` ON `user`.`company_id` = `company`.`id`

How can I implement it in yii2? I need dataprovider.
Tried like this but it doesn't work

$dataProvider = new ActiveDataProvider([
    'query' => Client::find()
                ->leftJoin('user', 'client.client_id = user.id')
                ->leftJoin('company', 'user.company_id = company.id')
]);

Here is the db structure

Answer 1

Write the relations in the User model and you can write $query = User::find()-> joinWith ('client')->joinWith('company').

Answer 2

For such simple things, I think it will be enough (item "Working with connected data").

Answer 3

'query' => Client::find()->joinWith(['user.company']);