获取权限是不是要写个子查询

获取权限是不是要写个子查询 SELECT permission FROM roles_permissions WHERE role_name IN (SELECT role_name FROM user_roles WHERE username = ?)