您的查询基本上是正确的，但要获得总数，您需要另一个子查询：

SELECT x.*, (FA + IA + LA + TA) as total
FROM (SELECT (SELECT COUNT(id) FROM c.fa WHERE foruser = 1) AS FA ,
             (SELECT COUNT(id) FROM c.ia WHERE foruser = 1) AS IA,
             (SELECT COUNT(id) FROM c.la WHERE foruser = 1) AS LA,
             (SELECT COUNT(id) FROM c.ta WHERE foruser = 1) AS TA
     ) x;

问题是不能在同一个目录中重复使用列别名 SELECT .
以上只是编写查询的一种方法。子查询通常放在 FROM 条款，允许：

SELECT FA.cnt, IA.cnt, LA.cnt, TA.cnt,
       (FA.cnt + IA.cnt + LA.cnt + TA.cnt) as total
FROM (SELECT COUNT(id) as cnt FROM c.fa WHERE foruser = 1) FA CROSS JOIN
     (SELECT COUNT(id) as cnt FROM c.ia WHERE foruser = 1) IA CROSS JOIN
     (SELECT COUNT(id) as cnt FROM c.la WHERE foruser = 1) LA CROSS JOIN
     (SELECT COUNT(id) as cnt FROM c.ta WHERE foruser = 1) TA;

我找到了答案：

SELECT SUM(FA+IA+LA+TA) AS TOTAL FROM (
(SELECT COUNT(id) AS FA FROM c.f WHERE foruser = 1 ) AS FAA,
(SELECT COUNT(id) AS IA FROM c.i WHERE foruser = 1) AS IAA  ,
(SELECT COUNT(id) AS LA FROM c.l WHERE foruser = 1 ) AS LAA ,
(SELECT COUNT(id) AS TA FROM c.t WHERE foruser = 1 ) AS TAA 
)

像我这样的人需要这个。