Schema that needs to joins twice from the same schema

export const games = sqliteTable("games", {
  id: text().primaryKey().$defaultFn(v4),
  redTeamId: text().references(() => teamScores.id),
  blueTeamId: text().references(() => teamScores.id),
}, (ts) => ({
  teamUniqueIdx: unique("team_unique_idx").on(ts.redTeamId, ts.blueTeamId),
}));

const game = await db.select()
      .from(games)
      .leftJoin(teamScores, eq(teamScores.id, games.redTeamId))
      .leftJoin(teamScores, eq(teamScores.id, games.blueTeamId))
      .then(firstOrNull);