User Multiple Roles in MySQL Database

I need to assign 4 roles.
The role has User , Manager , Admin , Super Admin

and some User will have 2 roles

each role There will be different personal information.
and giving a role to User will go through Register

I’m not sure what’s the best way to create a table.

I’m supposed to create 4 tables separated by roles.
Or how should I create the table?

please help me

and if possible I would also like to know how to set roles for page access. or query MySql