@lawjolla commented on
@Rob Murtagh’s file
https://prisma.slack.com/files/U9B4T6SNL/F9QQKLRJM/grouphasmembers_-_solution_.txt: I've used your exact approach and have yet to be burned. It's an old SQL problem and I'm 99% sure that's how they solved it. You can think of Membership as your User/Group Join table
If you think membershipClass may get more involved with types, you could make it its own node too, though you will pay a price in query join speed.