TypeORM -3个相关表之间的左连接/内连接问题

@Entity()
class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @OneToMany(() => Order, order => order.user)
  orders: Order[];
}

@Entity()
class Order {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  amount: number;

  @ManyToOne(() => User, user => user.orders)
  user: User;

  @OneToMany(() => Product, product => product.order)
  products: Product[];
}

@Entity()
class Product {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @ManyToOne(() => Order, order => order.products)
  order: Order;
}

const orders = await connection
  .getRepository(Order)
  .createQueryBuilder("order")
  .leftJoinAndSelect("order.user", "user")
  .getMany();

const orders = await connection
  .getRepository(Order)
  .createQueryBuilder("order")
  .innerJoinAndSelect("order.user", "user")
  .getMany();