select b.* from
(
select ip
from tb
group by ip
having count(user)>1
) a
left join tb b on a.ip=b.ip