If you are building a web API that perform selecting nested relation extensively. Consider serving a GraphQL server instead. seaography is a GraphQL framework for building GraphQL resolvers using SeaORM entities. With GraphQL resolver in place select above nested relation is straightforward and easy. Check "Getting Started with Seaography" to learn more.