根据角色获取用户组

SELECT *
FROM mems.user u
WHERE EXISTS (
    SELECT *
    FROM mems.usertorole
    WHERE roleId IN ("ADMIN")
        AND userId = u.userId
);