SELECT lw.id,
lw.uid,
lw.title,
SUM(lwl.voice_num) as voice_num,
lwl.title AS lists_title,
lwl.created_at,lw.is_finished,lw.collect_num FROM
(SELECT * FROM a WHERE pid != 0 ORDER BY created_at DESC LIMIT 10000) as lwl
LEFT JOIN b as lw ON lw.uid = lwl.work_id
GROUP BY lw.uid
mysql5.7如果不用limit限制ORDER BY不生效