mysql权限模型子查询 casewhen子查询

-- case when 子查询
SELECT
    COUNT( t.channel ),
    t.channel 
FROM
    ( SELECT 
    CASE f.source 
    WHEN '大红书' THEN '三方' 
    WHEN '小红书' THEN '新媒体'
    ELSE '搜索' END AS channel,
    f.source 
    FROM `for_ward` f ) t 
GROUP BY
    t.channel
    
-- rbac权限子查询    
SELECT
    * 
FROM
    permission p 
WHERE
    p.id IN (
    SELECT
        rp.permissionId 
    FROM
        role_permission rp 
WHERE
    rp.rid IN ( SELECT sr.rid FROM staff_role sr WHERE sr.sid = 117 ))