Yii2 Join Query

Yii2 provides many types of join:

• Join()
• leftJoin()
• rightJoin()
• joinWith()
• innerJoinWith()

In below example we are using Join() method.

Yii2 Join Query

$query = (new Query())->from('user');

$query->select('user.id , user_profile.first_name , user_profile.last_name');

$result = $query->join('left join', 'user_profile', 'user_profile.user_id = user.id')->all();