使用一条sql语句查询多表的总数

SELECT sum(列名1) 列名1,sum(列名2) 列名2,sum(列名3) 列名3 FROM (
SELECT count(*) 列名1, 列名2, 列名3 FROM 表1
-- WHERE plan_uid =
UNION ALL
SELECT 列名1,count(*) 列名2, 列名3 FROM 表2
-- WHERE other_uid =
UNION ALL
SELECT 0 列名1, 列名2,count(*) 列名3 FROM 表3
-- WHERE uid = AND status = 1
) t;