AuthItemChild Vs CTreeView

hi ppl

how can i: get nested items from AuthItemChild Table(rbac table) from db and then display it in CTreeView

i just need the recursive method to create data array !

db example:

| parent | child |

|-----------------------|

| admin | account |

|-----------------------|

| admin | site |

|-----------------------|

| site | product |

|-----------------------|

|site | deposit |

|-----------------------|

|deposit | foo |


thanks guys