how to generate xml from self join table

[seco]

Hi
i have one table that contains id,parent_id,name
the parent_id contains the id of the parent of this item
i want to generate xml from the table how?

thanks in advance.