php&mysql

COALESCE(sum(zqh_free_activity_goodsshare.by_share_member_sum),0);

array_sum(array_map(create_function('$val', 'return $val["get_user"];'),$getuser));

 

CASE
  
  WHEN p.jd_order_status = 19 THEN
  '完成' 
  WHEN p.jd_order_status = 17 THEN
  '拒收退款或拒收部分退款' ELSE CONCAT( p.jd_order_status, '其它', '-' ) 
 END