How to fetch nested responses in a select

[Gabriel-Passoss]

I'm using drizzle to make my queries, and in one of the queries I need to perform checks on foreign tables. From what I've researched, this type of query is a limitation of the ORM-based query. How would I be able to bring data from the database with the following formatting:

member: { user: { ...data } }, product: { ...data },