title: How to join 3 relation table using typeorm nestjs
body: <p>I am using typeorm with NestJs, I try to join 3 relations but got an error   <code>path comment.user in entity was not found</code></p>
  <p>Here is my table User</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Id</th>
  <th>username</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>row</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code> @PrimaryGeneratedColumn()
    id: number;
    @Column()
    username: string;
    @OneToMany(() =&gt; PostEntity, (post) =&gt; post.user, { eager: true })
    posts: PostEntity[];
  </code></pre>
  <p>Here is my table  Posts</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Id</th>
  <th>desc</th>
  <th>user_id</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>text</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code> @PrimaryGeneratedColumn()
    id: number;
    @Column()
    desc: string;
    @Column()
    userId: number;
  
    @ManyToOne(() =&gt; User, (user) =&gt; user.posts, {
      eager: false,
      onDelete: 'CASCADE',
    })
    user: User[];
    @OneToMany(() =&gt; CommentEntity, (comment: CommentEntity) =&gt; comment.post, {
      eager: true,
      onDelete: 'CASCADE',
    })
    comment: CommentEntity[];
  </code></pre>
  <p>Here is my table  comment</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Id</th>
  <th>comment</th>
  <th>user_id</th>
  <th>postId</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>comment post 1</td>
  <td>1</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <pre><code> @PrimaryGeneratedColumn()
    id: number;
    @Column()
    comment: string;
    @Column()
    userId: number;
    @Column()
    postId: number;
    @ManyToOne(() =&gt; PostEntity, () =&gt; (post: PostEntity) =&gt; post.comment, {
      eager: false,
      onDelete: 'CASCADE',
    })
  
    post: PostEntity[];
    @OneToOne(() =&gt; User)
    @JoinColumn()
    user: User;
  </code></pre>
  <p>In here I use OneToOne because 1 comment can comment by only 1 user</p>
  <p>this is what my data look like</p>
  <pre><code>```
  this.createQueryBuilder('post')
        .leftJoinAndSelect('post.user', 'user')
        .leftJoinAndSelect('post.comment', 'comment')
        .select(['post', 'user.id', 'user.username', 'comment'])
        .getMany();
  ```
  </code></pre>
  <p>this is what I get</p>
  <pre><code>[
    {
      id: 1,
      description: 'comment post 1',
      userId: 1,
      user: {
        id: 1,
        username: 'row',
      },
      comment: [
        {
          id: 1,
          description: 'comment',
          userId: 1,
          postId: 1,
        },
      ],
    },
  ];
  </code></pre>
  <p>In comment I want to join userId for user that comment . I want data look like this</p>
  <pre><code>[
    {
      id: 1,
      description: 'comment post 1',
      userId: 1,
      user: {
        id: 1,
        username: 'row',
      },
      comment: [
        {
          id: 1,
          description: 'comment',
          userId: 1,
          postId: 1,
          user: {
            // if different user comment will show different username
            id: 1, 
            username: 'row',
          },
        },
      ],
    },
  ];
  </code></pre>
  <p>This is what I try to do</p>
  <pre><code>this.createQueryBuilder('post')
        .leftJoinAndSelect('post.user', 'user')
        .leftJoinAndSelect('post.comment', 'comment')
        .leftJoinAndSelect('post.comment.user', 'user') 
        .select(['post', 'user.id', 'user.username', 'comment'])
        .orderBy('post.updated_at', 'DESC')
        .getMany();
  
  
   .leftJoinAndSelect('post.comment.user', 'user') // In this line I want to join userId but Its show an error  path comment.user in entity was not found
  </code></pre>
  <p><strong>UPDATE</strong></p>
  <p>I try to use this ( this mean PostEntity)</p>
  <pre><code>this.find({ relations: ['user', 'comment', 'comment.user']
  </code></pre>
  <p>but still not working</p>