how to convert recursive table to xml

[seco]

Hi
i have table that should iterate through it and make tree of xml nodes
the table has parent_id which contains the id of the parent of that row
table columns id,parent_id,name

i want to iterate through this table and generate xml file how?

thanks in advance.