在SQL中选择包含所有子项的父记录

SELECT parent.id, parent.name
FROM parent
WHERE parent.id IN (
    SELECT child.parent_id
    FROM child
    GROUP BY child.parent_id
    HAVING COUNT(child.id) = (
        SELECT COUNT(*)
        FROM child
        WHERE child.parent_id = parent.id
    )
);