Many to many relationship and linked table/collection

@John_D1 Have you found any solution for this issue?

The document increased dramatically. Any other way to create pivit table and access the data in a single query?