PHP

merge two query results in laravel

$teamStanding = Ladder::getTeamPosition($request->competitionId, $request->id)->get();

$teamStatistics = TeamCompetitionStatistics::getTeamStats($request->competitionId, $request->id)->get();

$merged = $teamStatistics->merge($teamStanding);

$result = $merged->all();

// return [{'teamstanding': 'data', 'teamstatictics': 'data'}]

laravel merge two query builder

$page = Page::select('id as page_id','name_en as page_name');
        $data['permissions'] = Permission::where('role_id', $id)->joinSub($page,'permissions_page',function($join){
            $join->on('permissions.page_id','=','permissions_page.page_id');
        })->get();

join multiple query in laravel

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