清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | select c.id as id,c.pId as pId,c. name as name ,c.checked as checked,c.type as type from ( select a.funtypeid id, 0 pId, a. name name , IF(( select COUNT (*) from t_role_function f,t_fun_item g where f.funid = g.funid and g.funtypeid = a.funtypeid AND f.roleid = 'systemuser' )>0, 'true' , 'false' ) as checked, 'parent' type from t_fun_type a union all select b.funid id, b.funtypeid pId, b.funname name , IF(( select COUNT (*) from t_role_function e where e.funid = b.funid AND e.roleid = 'systemuser' )>0, 'true' , 'false' ) as checked, 'childern' type from t_fun_item b ) c |