select u.name, w.uw as wins, l.ul as loses, d.ud as draws from user left join (select user, COUNT(id_won) uw from wons group by user) w on w.user = u.user_id left join (select user, COUNT(id_lose) ul from loses group by user) l on l.user = u.user_id left join (select user, COUNT(id_draw) ud from draws group by user) d on d.user = u.user_id
这只是完成任务所需的工作量。
