#找到了id跟总分 select b.name,a.add0 from ( #add select user_id,sum(grade_num) add0 from grade_info where type='add' group by user_id ) a left join user b on a.user_id=b.id order by a.add0 desc limit 1 ;