查询 email 域名 分组 各组条数

SELECT count(*),substring(email, instr(email, '@')) as a FROM hs_discuz_bbs.pre_common_member group by a ;