``` SELECT COUNT(*) AS `count` FROM (SELECT `name`,COUNT(*) AS number FROM zx_user GROUP BY `name` HAVING `name`=`name` AND number > 1) AS a; ```