项目中的一个和分页总数有关的子查询

SELECT count(*) as total_num FROM(SELECT COUNT(*) FROM table a

group by (a.sysmgr_user_name) ) as s