recently, we are working on a Spring Boot-based integrated rights management and authentication system for JWT and Shiro, but the data on the Internet is basically based on the operation of one table (the user table contains user information and their roles and permissions information), but my system stores the two tables separately (the user table is associated with the role and permissions table through foreign keys), but there are some conflicts during the Shiro operation, as shown in figure

:


Table 2 has a foreign key. Group_member is associated with user_email