mysql -- 统计分组记录数
# 查询分组数
SELECT count(*) from
(
SELECT count(*) as countnum
from u_userinfo
WHERE LENGTH(invitememberid) > 0
GROUP BY memberid
) t
# 查询分组数
SELECT count(*) from
(
SELECT count(*) as countnum
from u_userinfo
WHERE LENGTH(invitememberid) > 0
GROUP BY memberid
) t