CREATE TABLE  "Address"  (
     "id"         INTEGER NOT NULL,
     "nbLevel"    SMALLINT NOT NULL,
     "idMaster"   INTEGER 
       references  "Address" ( "id" ) on delete cascade,
     "chName"     VARCHAR( 63 ) COLLATE PXW_CYRL);

на входе                         на выходе
 id  nbLevel idMaster             id      l1      l2     l3
 ---------------------            ----------------------------
 
  1        1        null               1         1       null    null
  2        2          1                  2         1         2       null  
  3        2          1                  3         1         3       null
  4        3          2                  4         1         2         4 

select a3. "id" ,
       a1. "id" ,
       a2. "id" ,
       a3. "id" 
  from  "Address"  a1
       join  "Address"  a2 on a1. "id" =a2. "idMaster" 
       join  "Address"  a3 on a2. "id" =a3. "idMaster" 
 where a1. "nbLevel" = 1 
union
select a2. "id" ,
       a1. "id" ,
       a2. "id" ,
       cast(null as integer)
  from  "Address"  a1
       join  "Address"  a2 on a1. "id" =a2. "idMaster" 
 where a1. "nbLevel" = 1 
union
select a1. "id" ,
       a1. "id" ,
       cast(null as integer),
       cast(null as integer)
  from  "Address"  a1
 where a1. "nbLevel" = 1