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 vote212 views1 answer
Envoyer mail php depuis localhost
PHP
-1 vote142 views3 answers
Remove duplicate characters in a string in php
PHP
2 votes148 views1 answer
Install composer without requirement
PHP
1 vote145 views1 answer
Create controller codeigniter 3
PHP
2 votes111 views2 answers
Php save mysql result to array
PHP
1 vote147 views1 answer
How to check leap year in php?
PHP
0 vote139 views2 answers
Xml to object php
PHP
0 vote136 views1 answer
Php force array keys trim
PHP
5 votes139 views2 answers
In laravel date duration validation rule
PHP
0 vote337 views1 answer
Call to undefined method Illuminate\Session\Store::set()
PHP