select t2.shop, t2.user_id, t2.user_count from ( select shop, user_id, user_count, rank() over(partition by shop order by user_count)
`rank` from ( select shop,user_id,count(user_id)
`user_count` from Visit group by shop,user_id ) t1 ) t2 where t2.rank <= 3;