Add extra column from SQL recursive query, PostgreSQL

Language: Layout:

--PostgreSQL 9.6
--'\\' is a delimiter

create table t_package(
  id         int  primary key,
  name       text not null,
  parent_id  int               references t_package(id)
);

create table t_object(
  id         int  primary key,
  name       text not null,
  package_id int  not null     references t_package(id)
);

insert into t_package
values (10, 'First package',         13),
       (11, 'Second package',        10),
       (12, 'Third package',         14),
       (13, 'First root package',  NULL),
       (14, 'Second root package', NULL);

insert into t_object
values (1, 'First object',  11),
       (2, 'Second object', 11),
       (3, 'Third object',  14),
       (4, 'Fourth object', 12),
       (5, 'Fifth object',  14);

WITH RECURSIVE rcte(id, name, package_id, root_package_id) AS (
    SELECT    o.id, o.name, p.id, p.id
    FROM      t_package p
    LEFT JOIN t_object o  ON o.package_id = p.id
    WHERE     p.parent_id IS NULL
  UNION
    SELECT    o.id, o.name, c.id, p.root_package_id
    FROM      rcte p
    JOIN      t_package c ON c.parent_id  = p.package_id
    LEFT JOIN t_object o  ON o.package_id = c.id
)
SELECT   *
FROM     rcte
WHERE    id IS NOT NULL
ORDER BY id;


absolute service time: 0,41 sec