1. select count(1), t.ttName from (
    2. select tmp.*, sys_dept.name as ttName from
    3. (SELECT
    4.     sys_login_org.dept_id,
    5.     sys_login_log.usr_id,
    6.     sys_login_log.usr_name,
    7.     sys_login_log.work_no,
    8.     sys_login_log.sys_id,
    9.     sys_dept.id,
    10.     sys_dept.`name`,
    11.     sys_dept.path 
    12. FROM
    13.     sys_login_log,
    14.     sys_login_org,
    15.     sys_dept 
    16. WHERE
    17.     sys_login_log.id = sys_login_org.login_id 
    18.     AND sys_dept.id = sys_login_org.dept_id) tmp
    19.     left join sys_dept on FIND_IN_SET(sys_dept.id,REPLACE(tmp.path,'/',','))
    20.     ) t
    21.     group by t.ttName
    22. --     where tmp.work_no = '-1'
    23. ;
    24. SELECT
    25. sys_login_log.id as logid,
    26.     sys_login_org.dept_id,
    27.     sys_login_log.usr_id,
    28.     sys_login_log.usr_name,
    29.     sys_login_log.work_no,
    30.     sys_login_log.sys_id,
    31. --     sys_dept.id,
    32.     sys_dept.`name`,
    33.     sys_dept.path 
    34. FROM
    35.     sys_login_log,
    36.     sys_login_org,
    37.     sys_dept 
    38. WHERE
    39.     sys_login_log.id = sys_login_org.login_id 
    40.     AND sys_dept.id = sys_login_org.dept_id
    41.     and  sys_login_log.usr_id = 817441901144702976
    42.     order by sys_login_log.id,sys_login_org.dept_id 
    43.     ;
    45.     select tmp.*, sys_dept.name as ttName, sys_dept.id deptID  from (SELECT
    46. sys_login_log.id as logid,
    47.     sys_login_org.dept_id,
    48.     sys_login_log.usr_id,
    49.     sys_login_log.usr_name,
    50.     sys_login_log.work_no,
    51.     sys_login_log.sys_id,
    52. --     sys_dept.id,
    53.     sys_dept.`name`,
    54.     sys_dept.path 
    55. FROM
    56.     sys_login_log,
    57.     sys_login_org,
    58.     sys_dept 
    59. WHERE
    60.     sys_login_log.id = sys_login_org.login_id 
    61.     AND sys_dept.id = sys_login_org.dept_id
    62.     and  sys_login_log.usr_id = 817441901144702976) tmp
    63.     left join sys_dept on FIND_IN_SET(sys_dept.id,REPLACE(tmp.path,'/',','))
    64.   order by tmp.logid,deptID;
    66.     select count(1), count(distinct b.usr_id) as access_person,dept_id, name from (
    67.     select l.id, l.usr_id, l.work_no, dd.name, dd.path,dd.id as dept_id,l.sys_id from sys_login_log l left join (
    68.         select GROUP_CONCAT(d.path SEPARATOR '/' ) as path, o.login_id from sys_login_org o, sys_dept d where o.dept_id = d.id
    69.         GROUP BY o.login_id
    70.     ) a on l.id = a.login_id
    71.     left join sys_dept dd on FIND_IN_SET(dd.id,REPLACE(a.path,'/',','))
    72. --     order by l.id, dept_id
    73.     ) b 
    74.     group by dept_id, name;
    75.     select l.id, l.usr_id, l.work_no, dd.name, dd.path,dd.id as dept_id,l.sys_id from sys_login_log l left join (
    76.         select GROUP_CONCAT(d.path SEPARATOR '/' ) as path, o.login_id from sys_login_org o, sys_dept d where o.dept_id = d.id
    77.         GROUP BY o.login_id
    78.     ) a on l.id = a.login_id
    79.     left join sys_dept dd on FIND_IN_SET(dd.id,REPLACE(a.path,'/',','))
    80.     where dd.id = 1;
    82.     -- dept person amount
    83.     select 
    84. --     a.path, a.user_id, 
    85. count(1),
    86.     dd.id, dd.name from sys_dept dd INNER JOIN (
    87.     select u.user_id, GROUP_CONCAT(d.path SEPARATOR '/') as path from sys_dept_users u,sys_dept d where u.dept_id = d.id GROUP BY u.user_id) a on 
    88.      FIND_IN_SET(dd.id,REPLACE(a.path,'/',','))
    89.      GROUP BY dd.id, dd.name
    90.      ;
    93.     select count(1) as access_amount, count(distinct b.usr_id) as access_person,dept_id, name, ttt.total_person from (
    94.     select l.id, l.usr_id, l.work_no, dd.name, dd.path,dd.id as dept_id,l.sys_id from sys_login_log l left join (
    95.         select GROUP_CONCAT(d.path SEPARATOR '/' ) as path, o.login_id from sys_login_org o, sys_dept d where o.dept_id = d.id
    96.         GROUP BY o.login_id
    97.     ) a on l.id = a.login_id
    98.     left join sys_dept dd on FIND_IN_SET(dd.id,REPLACE(a.path,'/',','))
    99.     ) b INNER JOIN (
    100.     select  
    101. count(1) as total_person,
    102.     dd.id from sys_dept dd INNER JOIN (
    103.     select u.user_id, GROUP_CONCAT(d.path SEPARATOR '/') as path from sys_dept_users u,sys_dept d where u.dept_id = d.id GROUP BY u.user_id) a on 
    104.      FIND_IN_SET(dd.id,REPLACE(a.path,'/',','))
    105.      GROUP BY dd.id) ttt on b.dept_id = ttt.id
    106.     group by dept_id, name;