join tables with conditions eloquent code example
Example: laravel join 2 tables eloquent
$select->joinSub(
$selectSubQry,
'ag',
'ag.id',
'=',
'agp.userId'
);