How to relate the middle table with One or Many relationship?
If a user can have no more than a single role, and this will ever change, then put role_id directly on the user table, then the relationship between role table and user table is a single role to many users.