typeorm query spesific selecion about typeorm HOT 1 OPEN

// you can use with find, findOne, findOneOrFail
repository.find({
  select: {
    id: true,
    role: {
      id: true,
      name: true,
    }
  },
  relations: {
    role: true,
  },
  where: {
    id: In([1, 2, 3]),
  }
});

manager.createQueryBuilder(User, 'user')
  .select('user.id')
  .addSelect('role.id')
  .addSelect('role.name')
  .innerJoin('user.role', 'role')
  .where('user.id IN (:...ids)', { ids: [1, 2, 3] })
  .getMany();