如何使用TypeORM leftJoinAndSelect连接多个表？

import { getConnection } from "typeorm";
import { User } from "./entities/User";
import { Post } from "./entities/Post";
import { Comment } from "./entities/Comment";

async function getUsersWithPostsAndComments() {
  const connection = getConnection();
  const userRepository = connection.getRepository(User);

  const users = await userRepository
    .createQueryBuilder("user")
    .leftJoinAndSelect("user.posts", "post")
    .leftJoinAndSelect("post.comments", "comment")
    .getMany();

  return users;
}