withCount('etudes')->get(); $schoolYear = $service->getActiveSchoolYear(); $currentSet = []; $etudes = []; foreach ($ensembles as $ensemble) { $thisSet = $service->getSetForEnsemble($ensemble); $currentSet[$ensemble->id] = $thisSet; $etudes[$ensemble->id] = $ensemble ->etudes()->where('set', '=', $thisSet) ->get()->keyBy('instrument_id'); } return view('etudes', compact('ensembles', 'schoolYear', 'currentSet', 'instruments','etudes')); } }