how to model this query in drizzle

SELECT 
  tournaments.id, 
  tournaments.title, 
  tournaments.info, 
  tournaments.due_date, 
  tournaments.registration, 
  winner.name AS winner,
  runner_up.name AS runner_up,
  most_points.name AS most_points
FROM tournaments
INNER JOIN users AS winner ON tournaments.winner = winner.id
INNER JOIN users AS runner_up ON tournaments.runner_up = runner_up.id
INNER JOIN users AS most_points ON tournaments.most_points = most_points.id
WHERE tournaments.id = '45FobTao63vsRyc1N1';


I currently have this:
  const tmp = await db
    .select({
      ...getTableColumns(tournaments_table),
      // id: tournaments_table.id,
      winner: tournaments_table.winner,
      runner_up: tournaments_table.runner_up,
      most_points: tournaments_table.most_points,
    })
    .from(tournaments_table)
    .innerJoin(users_table, eq(tournaments_table.winner, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.runner_up, users_table.id))
    .innerJoin(users_table, eq(tournaments_table.most_points, users_table.id))
    .where(eq(tournaments_table.id, params.id));


but I get an error saying:
Error: Alias "users" is already used in this query
Was this page helpful?