select uid, 
count(uid) as cnt
from user_client_log 
where step = 'order'
group by uid
order by cnt desc,uid
limit 3

简单