SELECT c.`name`,sum(c.number)

FROM?

(SELECT a.`name`,a.number,b.`status`

FROM order_detail as a LEFT JOIN orders as b?ON?a.order_id=b.id and b.`status`=5) as c

GROUP BY c.`name`