select P PCCUSTOMER_ID select count from T_PROJECT_CUSTOMER where PROJECT_ID=PID as CUSTOMER_COUNTfrom T_PROJECT P LEFT JOIN T_PROJECT_CUSTOMER PC ON PCPROJECT_ID = PIDwhere 1 = 1order by STATUS

您可以使用GROUP BY子句将结果按ID进行分组，并使用GROUP_CONCAT函数将CUSTOMER_ID列合并为一个字符串。更新后的查询如下：

SELECT
  P.ID,
  GROUP_CONCAT(PC.CUSTOMER_ID) AS CUSTOMER_ID,
  COUNT(PC.CUSTOMER_ID) AS CUSTOMER_COUNT,
  P.NAME,
  P.STATUS
FROM
  T_PROJECT P
  LEFT JOIN T_PROJECT_CUSTOMER PC ON PC.PROJECT_ID = P.ID
WHERE
  1 = 1
GROUP BY
  P.ID
ORDER BY
  P.STATUS DESC,
  P.NAME DESC

这将返回以ID为组的结果，其中CUSTOMER_ID列已经合并，并且CUSTOMER_COUNT列表示每个项目的客户数量。