Use same Postgres WITH in multiple queries
You can chain multiple CTEs that perform an INSERT:

with x (id) as (
  insert into ... 
  returning id
), t2_insert as (
  insert into t2 (id)
  select id
  from x
)
insert into t3
select id
from x;