SELECT 
    uid,
    cast(sum(if(step='order',1,0)) AS SIGNED) AS cnt
FROM user_client_log
GROUP BY uid
ORDER BY sum(if(step='order',1,0)) DESC,uid 
LIMIT 3;