Join multiple query in laravel

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

Laravel eloquent multiple join with where conditions

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Source: tutsmake.com

Similar codes

22 votes161 views6 answers
Php array merge
PHP
1 vote188 views1 answer
Laravel websockets onsubscribe
PHP
0 vote229 views2 answers
Yii2 get cookie
PHP Yii
-1 vote205 views1 answer
Codeigniter 4 query builder select
PHP
1 vote219 views2 answers
Laravel session put method
PHP Laravel
0 vote219 views1 answer
List all subcategories from category
PHP
36 votes170 views5 answers
Php refresh page
PHP
0 vote169 views1 answer
Remove WordPress Login error hints
PHP Wordpress
21 votes265 views1 answer
How to get last array element in php
PHP
1 vote231 views1 answer
Group_concat laravel
PHP