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