typescript - Load additional relationships in many-to-many query

Question

I have a many-to-many relationship between User and Car. I would like to get all the Cars owned by the User, so I am doing this with TypeORM's Query Builder:

const cars = this.createQueryBuilder('car')
  .leftJoinAndSelect('car.users', 'user')
  .where('user.id = :userId ', { userId })
  .getMany();

This works, it returns an array of Car records that belongs to the User ID. But now the problem is that if I access one of the records' .users, the only present User is the one that the query is using to look up the Cars. I would like to be able to retrieve all the Users belonging to each Car's record. The User ID should only be used to restrict the returned Car records to the User looking it up.

How would I modify this query to return all the Users that belong to each Car record?

Table setup

@Entity()
export class User extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: string;

  @ManyToMany(() => Car, (car) => car.users)
  @JoinTable()
  cars: Car[];
}

@Entity()
export class Car extends BaseEntity {
  @PrimaryGeneratedColumn()
  id: string;

  @ManyToMany(() => User, (user) => user.cars)
  users: User[];
}

Desired output

Given two Cars of ID 1 and 2 exist, and both have Users of ID 3, 4, and 5 assigned to them. User 3 is performing the lookup.

[
  Car {
    id: 1,
    users: [
      User { id: 3 },
      User { id: 4 },
      User { id: 5 },
    ],
  },
  Car {
    id: 2,
    users: [
      User { id: 3 },
      User { id: 4 },
      User { id: 5 },
    ],
  },
]

Actual output

The User ID used to perform the lookup is the only returned User of each Car.

[
  Car {
    id: 1,
    users: [ User { id: 3 } ]
  },
  Car {
    id: 2,
    users: [ User { id: 3 } ]
  },
]

question from:https://stackoverflow.com/questions/66054596/load-additional-relationships-in-many-to-many-query

Answer 1

Waitting for answers