mysql - 如何合并select * 和select count(*)两种结果？

Answer 1

SELECT s1.*,IF(s2.PID IS NULL,0,1) 
    FROM SM_ORGANIZETION s1 
    LEFT JOIN (
        SELECT PID 
        FROM SM_ORGANIZETION 
        GROUP BY PID) s2
     ON s1.ID=s2.PID;