如何让内连接在TypeORM上工作？

// User.ts
import { Entity, PrimaryGeneratedColumn, Column, OneToMany } from 'typeorm';
import { Post } from './Post';

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

  @Column()
  name: string;

  @OneToMany(() => Post, post => post.user)
  posts: Post[];
}

// Post.ts
import { Entity, PrimaryGeneratedColumn, Column, ManyToOne } from 'typeorm';
import { User } from './User';

@Entity()
export class Post {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  title: string;

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

import { getRepository } from 'typeorm';
import { User } from './User';
import { Post } from './Post';

async function getPostsWithAuthors() {
  const result = await getRepository(Post)
    .createQueryBuilder('post')
    .innerJoinAndSelect('post.user', 'user')
    .getMany();

  return result;
}