如何使用SQL选择最高计数的父项和子项

SELECT parent_id, COUNT(*) AS child_count
FROM child
GROUP BY parent_id

SELECT parent_id, MAX(child_count) AS max_child_count
FROM (
    SELECT parent_id, COUNT(*) AS child_count
    FROM child
    GROUP BY parent_id
) AS temp

SELECT parent.parent_id, parent.parent_name, child.child_id, child.child_name
FROM parent
INNER JOIN child ON parent.parent_id = child.parent_id
INNER JOIN (
    SELECT parent_id, MAX(child_count) AS max_child_count
    FROM (
        SELECT parent_id, COUNT(*) AS child_count
        FROM child
        GROUP BY parent_id
    ) AS temp
) AS max_count ON parent.parent_id = max_count.parent_id AND COUNT(*) = max_count.max_child_count