如何在视图mysql中为多个父id重复所有子id

CREATE TABLE parent_child (
    parent_id INT,
    child_id INT
);

INSERT INTO parent_child (parent_id, child_id) VALUES
(1, 10),
(1, 11),
(2, 12),
(2, 13);

CREATE VIEW repeated_children AS
WITH RECURSIVE cte AS (
    SELECT parent_id, child_id
    FROM parent_child
    WHERE parent_id IN (1, 2) -- 这里指定你想要的父ID列表
    UNION ALL
    SELECT p.parent_id, c.child_id
    FROM parent_child p
    INNER JOIN cte c ON p.parent_id = c.parent_id
)
SELECT parent_id, child_id FROM cte;

CREATE VIEW repeated_children AS
SELECT parent_id, child_id
FROM parent_child
WHERE parent_id IN (1, 2); -- 这里指定你想要的父ID列表