Many-to-Many joins results in weird values

  const teamedUser = await db.select().from(usersToTeams)
    .where(eq(usersToTeams.user, user.id))
    .innerJoin(users, eq(usersToTeams.user, users.id))
    .innerJoin(teams, eq(usersToTeams.team, teams.id))
    .all();

[
  {
    usersToTeams: { user: 4, team: 2 },
    users: {
      id: 2,
      email: '<email>',
      password: '<password-hash>',
      name: '<this field is undefined, but weirdly it puts in the users email>'
    },
    teams: { id: undefined, name: undefined }
  }
]

import { eq, sql, getTableColumns} from "drizzle-orm";


const {id: userId, ...userRest} = getTableColumns(user)
const {id: teamId, ...teamRest} = getTableColumns(team)

console.log(db.select({
  user: {
    userId: sql`${userId}`.as("user_id"),
    ...userRest
  },
  team: {
    teamId: sql`${teamId}`.as("team_id"),
    ...teamRest
  }
})
  .from(usersToTeams)
  .innerJoin(user, eq(usersToTeams.userId, user.id))
  .innerJoin(team, eq(usersToTeams.teamId, team.id))
  .toSQL());