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();

It does work, but the resulting query isn't fully accurate:

select * from `game` where `game`.`deleted_at` is null and `game`.`hometeam` = '14' and `game`.`hometeam` is not null or `awayteam` = '14'

Since the or condition thusly ignores the deleted_at is null (important) and there is no check for awayteam is not null.

Also, I'd want to further qualify the conditions (a date range specifically) so perhaps there is no (good/easy?) relationship way to handle this case and I do just need to have a query.

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