Join with and condition

Yii 2.0 General Discussions
1

How can we implment this with yii2 model query

-> ON a.id = b.id AND user_id=X

This work for left join but how can i add AND condition with join in below query

$query->select([

                'a.id',


                'b.id',


                'b.user_id',


            ->from('a')


            ->leftJoin('b', 'a.id = b.id');
2

Tried with




->leftJoin('b', 'a.id = b.id AND user_id = '.$X);

?