Mostrar Categorias en PHP

[enlinea777]

Pues con esta query

Código MySQL:

select id, nombre1, nombre2, nombre3 from
(SELECT *, nombre as nombre3 FROM `categorias`
left join (SELECT id as idt2, nombre as nombre2, parent_id as  parent_id_t2  FROM `categorias`) as t2 on (parent_id=idt2)
left join (SELECT id as idt1, nombre as nombre1, parent_id as  t2parent_id  FROM `categorias`) as t1 on ( parent_id_t2=idt1)
 WHERE  `id`=9) as cats
 

ESTE ES ELRESULTADO

http://prntscr.com/2nu7m8

o para verlo en filas:

Código MySQL:

(select "1" as id, nombre1 as nombre from
(SELECT *, nombre as nombre3 FROM `categorias`
left join (SELECT id as idt2, nombre as nombre2, parent_id as  parent_id_t2  FROM `categorias`) as t2 on (parent_id=idt2)
left join (SELECT id as idt1, nombre as nombre1, parent_id as  t2parent_id  FROM `categorias`) as t1 on ( parent_id_t2=idt1)
 WHERE  `id`=9) as cats )
UNION(select "2" as id, nombre2 as nombre from
(SELECT *, nombre as nombre3 FROM `categorias`
left join (SELECT id as idt2, nombre as nombre2, parent_id as  parent_id_t2  FROM `categorias`) as t2 on (parent_id=idt2)
left join (SELECT id as idt1, nombre as nombre1, parent_id as  t2parent_id  FROM `categorias`) as t1 on ( parent_id_t2=idt1)
 WHERE  `id`=9) as cats )UNION(
select "3" as id, nombre3 as nombre from
(SELECT *, nombre as nombre3 FROM `categorias`
left join (SELECT id as idt2, nombre as nombre2, parent_id as  parent_id_t2  FROM `categorias`) as t2 on (parent_id=idt2)
left join (SELECT id as idt1, nombre as nombre1, parent_id as  t2parent_id  FROM `categorias`) as t1 on ( parent_id_t2=idt1)
 WHERE  `id`=9) as cats )
 

resultado:

http://prntscr.com/2nu72n

se ve complicado pero no lo es, si es autogenerada la query con php.