How to retrieve a nested relationship using TypeORM

You have a TypeORM entity. It has a relationship. The relationship entity has a nested relationship to a third. And you need that third entity to save the world and crack the bank vault open. How the hell do we get it?

How to retrieve a nested relationship using TypeORM
Photo by Tobias Fischer / Unsplash

Given a OneToMany relationship to an entity containing a ManyToOne relationship, how do we retrieve the nested relationship's entity when making a MySQL query using TypeORM?

Let's say we have chairs, which are assigned to users via chairs assignments, and users. This would be our main entity's model: