조인키가 없으므로 인조 조인키를 만들어 줘야 합니다.
ROW_NUMBER() OVER(PARTITION BY id ORDER BY 1) 이런 식입니다.
각 테이블마다 ID 별 순번을 부여하여 이 순번으로 조인하면 되는데...
MySQL 에서는 ROW_NUMBER 기능이 없죠.
 

SELECT a.id
     , b.pw
     , f.family
     , f.friend
  FROM tab_a a
 INNER JOIN tab_b b
    ON a.id = b.id
  LEFT OUTER JOIN
       (SELECT id
             , rn
             , MIN(family) family
             , MIN(friend) friend
          FROM (SELECT c.id
                     , COUNT(c1.id) rn
                     , c.family
                     , null friend
                  FROM tab_c c
                  LEFT OUTER JOIN tab_c c1
                    ON c.id = c1.id
                   AND c.family > c1.family
                 GROUP BY c.id, c.family
                 UNION ALL
                SELECT d.id
                     , COUNT(d1.id) rn
                     , null family
                     , d.friend
                  FROM tab_d d
                  LEFT OUTER JOIN tab_d d1
                    ON d.id = d1.id
                   AND d.friend > d1.friend
                 GROUP BY d.id, d.friend
                ) e
         GROUP BY id, rn
        ) f
    ON a.id = f.id
 ORDER BY id, rn
;