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

0 vote297 views1 answer
What Permissions do I need for include folder on php
PHP
63 votes493 views6 answers
Clear all cache in laravel
PHP Laravel
9 votes299 views3 answers
How to convert array to string with commas in php
PHP
0 vote311 views1 answer
Controller class does not exist laravel
PHP
104 votes532 views6 answers
String replace in php
PHP
0 vote357 views1 answer
Return json in middleware laravel
PHP Laravel
0 vote366 views2 answers
If condition in laravel blade in select option
PHP Laravel
4 votes318 views2 answers
Get session blade
PHP
13 votes321 views6 answers
Laravel delete
PHP Laravel
1 vote399 views1 answer
Codeigniter 3 Configured database connection has cache enabled
PHP CodeIgniter