高级语言采用左连接统计总和

以ec二开为例。怎么查询出某个供应商的所有已分发数量之和，采用左连接，如果没有分发，返回NULL

$_sql = "SELECT 

gt.gift_id,
g.gift_name,
gt.tran_number,
gt.remain_number,
gt.tran_number-IFNULL(send.send_num,0)-gt.remain_number as receive,
send.send_num
FROM (".$ecs->table('gift')." g,".$ecs->table('gift_tran')." gt)
LEFT JOIN(
SELECT 
gift_id,
sum(tran_number) as send_num 
FROM 
".$ecs->table('gift_tran')."  
WHERE 
from_supplier_id = $supplier_user_id
GROUP BY 
gift_id
) as send ON send.gift_id=gt.gift_id 
WHERE 
gt.to_supplier_id=$supplier_user_id 
AND g.gift_id = gt.gift_id";