Please tell me, I have a very complicated idea.
I'm making an event app, events can be created by clubs, and a club can have people with the roles of President and Staff
and only they can create events.
I have a roles table.
as well as the user_roles many to many table, a user can be the president of many clubs, or be on the staff of other clubs
The problem now is that I'm trying to implement a method to get information about which clubs the user has access to create events.