select 1 as id, null as pid, 'testX' as name from dual
union all
select 2 as id, null as pid, 'test2' as name from dual
union all
select 3 as id, 2 as pid, 'test3' as name from dual
union all
select 4 as id, 3 as pid, 'testX' as name from dual
union all
select 5 as id, 3 as pid, 'test5' as name from dual
union all
select 6 as id, 3 as pid, 'test6' as name from dual
union all
select 7 as id, 4 as pid, 'test7' as name from dual
union all
select 8 as id, 5 as pid, 'test8' as name from dual
union all
select 9 as id, 3 as pid, 'test9' as name from dual
union all
select 10 as id, 4 as pid, 'test10' as name from dual
union all
select 11 as id, 5 as pid, 'testX' as name from dual
union all
select 12 as id, 5 as pid, 'test12' as name from dual

where name = 'testX'