LEFT join AND command in yii2

Question

I want to write a request in yii2 and I don’t know how to write it. I tried several things from the documentation, but my request didn’t work.

SELECT notification.*,event.title,user.firstname,user.lastname FROM notification 
LEFT JOIN event ON event.id = notification.source_id 
AND notification.activity_type = "checkin"
Where user.firstname in (select id from user where user_id=1) 
LEFT JOIN user ON user.id = notification.source_id 
AND notification.activity_type = "friend" 
Where user.firstname in (select id from user where user_id=1)

and here is the query that I am writing now, I need to add the AND function in the same way as in the query

    $query  ->select(['notification.*,event.title,user.firstname,user.lastname'])
            ->from('notification')
            ->leftJoin('event', 'event.id = notification.source_id')
            ->leftJoin('user', 'user.id = notification.source_id');

Answer 1

Have you tried the following:

$query  ->select(['notification.*,event.title,user.firstname,user.lastname'])
            ->from('notification')
            ->leftJoin('event', 'event.id = notification.source_id AND notification.activity_type = "checkin" ')
            ->leftJoin('user', 'user.id = notification.source_id AND notification.activity_type = "friend"');