title: TypeORM: Make a select request with relation and where
body: <p>I do an API with NestJS and the ORM TypeORM</p>
  
  <p>I have for entity:</p>
  
  <p>User</p>
  
  <p>RelationshipType</p>
  
  <p>UserRelationshipType (with user and relationshiptype ForeignKey)</p>
  
  <p>And Relationship (with userRelationshipType ForeignKey)</p>
  
  <p>And need to find all the relationship, but from specific user
  So I need somewhere to declare "user.id = id"</p>
  
  <p>I have done that with createQueryBuilder</p>
  
  <pre><code>this.repo
      .createQueryBuilder('relationship')
      .innerJoinAndSelect(
        'relationship.userRelationshipType',
        'userRelationshipType',
      )
      .innerJoinAndSelect(
        'userRelationshipType.user',
        'user',
        'user.id = :id',
        { id: id },
      )
      .innerJoinAndSelect(
        'userRelationshipType.relationshipType',
        'relationshipType',
      )
      .getMany()
  </code></pre>
  
  <p>And it's work
  But I'm not happy because I want to do all my request with the .find or findOne</p>
  
  <p>And when I'm doing</p>
  
  <pre><code>this.repo.find({
  
    relations: [
  
      'userRelationshipType',
  
      'userRelationshipType.user',
  
      'userRelationshipType.relationshipType',
  
    ],
  
    where: {userRelationshipType: {user: {id: id}}}
  
  });
  </code></pre>
  
  <p>that doesn't work... but in the doc it's say to do that...
  I can find all, but can apply the good where condition (or join condition)
  Have you an idea?</p>
  
  <p>I have tried with join also, but i'm a little bit lost</p>
  
  <p>Thanks :)</p>