mysql查询增加表头
select '微信支付流水号' as juan_orderno
,'捐赠人'
,'手机号码'
,'捐赠金额'
,'捐赠时间'
,'捐赠项目'
,'捐赠人备注'
)
union all
(
select juan_orderno
,juan_name
,juan_phone
,juan_price
,juan_addtime
,case_name
,juan_remark
from `juan`
join `case` on juan_case_id=case_id
where juan_status=1
)
order by juan_orderno desc