与PostgreSQL建立一对多关系的SQL查询

CREATE TABLE parent (
    id SERIAL PRIMARY KEY,
    name VARCHAR(50)
);

CREATE TABLE child (
    id SERIAL PRIMARY KEY,
    name VARCHAR(50),
    parent_id INT REFERENCES parent(id)
);

INSERT INTO parent (name) VALUES ('Parent 1');
INSERT INTO parent (name) VALUES ('Parent 2');

INSERT INTO child (name, parent_id) VALUES ('Child 1', 1);
INSERT INTO child (name, parent_id) VALUES ('Child 2', 1);
INSERT INTO child (name, parent_id) VALUES ('Child 3', 2);

SELECT parent.id, parent.name, child.id, child.name
FROM parent
LEFT JOIN child ON parent.id = child.parent_id;