how get account tree through query from vfp table

[mfa]

hi,
i have table with to field father and child

father child
================
null | 1
1 | 11
11 | 111
111 | 1111
null | 2
2 | 21
21 | 211
1 | 12
12 | 121
12 | 122
null | 3
3 | 31
31 | 311
211 | 2111
311 | 3111

and i need result in this form

child
=====
1
11
111
1111
11111
12
121
1211
12111
3
31
311
3111
31111

i complete in oracel by using connect by function
but in foxpro i can not

please send me query in foxpro