如何使用WITH查询插入到表中，并将返回的id插入到另一个表中？

WITH temp_table AS (
  SELECT column1, column2, ... FROM source_table
)

INSERT INTO target_table (column1, column2, ...)
SELECT column1, column2, ...
FROM temp_table
RETURNING id;

INSERT INTO another_table (id_column)
SELECT id
FROM (
  INSERT INTO target_table (column1, column2, ...)
  SELECT column1, column2, ...
  FROM temp_table
  RETURNING id
) AS inserted_ids;