public function viewScore(Application $application) { $criteria = Criteria::get(); $judges = User::where(['role' => 'judge'])->get(); $judgeScores = []; // Select all scores made by each judge foreach ($judges as $judge) { $scores = $application->scores()->where('user_id', $judge->id)->get(); foreach ($scores as $score) { $judgeScores[$judge->id][$score->criteria_id] = $score->score; } } return view('pages/scores/view', compact('application', 'criteria', 'judges', 'judgeScores')); }