/** * Clubs */ public function getClubs(Season $season, Competition $competition) { return $competition->clubsByName()->select('clubs.*', 'locations.name as location')->join('locations', 'clubs.location_id', '=', 'locations.id')->wherePivot('season_id', '=', $season->id)->get()->toArray(); }