SELECT
*
FROM
xzllgj_user_free_60m
WHERE
user_id IN (
SELECT
user_id
FROM
xzllgj_user_free_60m
GROUPBY
user_id
HAVING
(COUNT(*))> 1
)
SELECT
*
FROM
xzllgj_user_free_60m
WHERE
user_id IN (
SELECT
user_id
FROM
xzllgj_user_free_60m
GROUPBY
user_id
HAVING
(COUNT(*))> 1
)