How to write such a query in Yii2?

Question

MySQL

Hello. How to write such query in Yii2 using ActiveRecords ?
SELECT *
FROM `match`
LEFT JOIN `group` ON `group`.`id` = `match`.`id_group`
LEFT JOIN `group_lists` ON ​​`group_lists`.`id_group` = `match`.`id_group`
WHERE ` group`.`id_tourney` = 1
GROUP BY `match`.`id`

Answer 1

$models = Math::find()->with(['group_lists', 'group' => function($query) {
                   $query->andWhere(['id_tourney' => 1 ]);
           }
  ])->all();

Try like this...