select count(*) as num,u.email from eload_order_info as o
LEFT JOIN eload_users as u on u.user_id = o.user_id
GROUP BY o.user_id ORDER BY num desc LIMIT 0,10
select * from (select count(*) as num,u.email from eload_order_info as o
LEFT JOIN eload_users as u on u.user_id = o.user_id
GROUP BY o.user_id ) as temp order by num desc LIMIT 0,10