Group By无分组数据补0
SELECT
A.type,
A.typeName,
ifnull(super.amount,0)
FROM
(
SELECT 0 AS type,"娱乐主播" AS typeName
UNION ALL
SELECT
A.type,
A.typeName,
ifnull(super.amount,0)
FROM
(
SELECT 0 AS type,"娱乐主播" AS typeName
UNION ALL