OneToMultipleMany DB Schema

example.txt

(Simplified schema)
CREATE TABLE season
(
    id INT(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
    year YEAR(4) NOT NULL,
    teamid SMALLINT(5) UNSIGNED NOT NULL,
    levelid TINYINT(3) UNSIGNED,
    divid MEDIUMINT(9),
    district TINYINT(4),
);

CREATE TABLE game
(
    gameid INT(11) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
    hometeam SMALLINT(5) UNSIGNED NOT NULL,
    awayteam SMALLINT(5) UNSIGNED NOT NULL,
    homescore TINYINT(4) UNSIGNED NOT NULL,
    awayscore TINYINT(4) UNSIGNED NOT NULL,
    date DATE DEFAULT '0000-00-00' NOT NULL,
    time TIME DEFAULT '00:00:00' NOT NULL,
);

What I have to do (which doesn't allow eagar loading) in a controller:
// Load Season
$season = Season::where(['teamid' => $team, 'year' => $year])->first();

// Load Games (not eager)
$away = Game::where(['awayteam' => $team])
    ->whereBetween('date', [$start, $end])
    ->orderBy('date')
    ->get();

$home = Game::where(['hometeam' => $team])
    ->whereBetween('date', [$start, $end])
    ->orderBy('date')
    ->get();

$games = $away->merge($home)->sortBy('date');

What would be awesome in Season model:
public function games()
{
  return $this->hasMultipleMany(['App\Team', 'hometeam', 'teamid'], ['App\Team', 'awayteam', 'teamid']);
}

$season = Season::where(['teamid' => $team, 'year' => $year])->with('games')->first();

Can you write the raw sql you would like to see, just to "test" against what I am writing as an attempt?