How to create define fetch and render logic on a page?

Question

Laravel

There are users who are assigned groups. Each group has sections where crud functions are available.
For example:
There are groups: root, admin, doctor.
There are users: user1, user2, user3.
user1-root(database(r)); user_role_access(crud))/admin(status_order(crud))
user2-root(database(r)); user_role_access(r))
user3-doctor(patients(cru))
Let's say user1 went on vacation, and user3 became the head of the department and was given the opportunity to delete records.
It becomes like this:
user2-root(database(crud)); user_role_access(crud))
user3-doctor(patients(crud))
How many and which tables should be created and how to link?
The users and roles tables have already been created. role_user is also created.