1、安全中心库表，角色表 access_groups 和用户表 access_users
select * from access_groups limit 10;

select * from access_users limit 10;

2、关联查询角色下对应的用户

#比如要查询mammut_service对应项目下的全部成员,where 条件 name

select * from access_groups where name = 'mammut_service_6';

使用access_groups.id关联两张表

select access_users.id, access_users.name, access_users.description,  
access_users.principal, access_users.create_time, access_users.update_time  
from access_users inner join access_group_users  
on access_group_users.user_id = access_users.id  
and access_group_users.group_id = 8;

作者：张鸿运