问一个SQL的问题

Question

100     1     110000 
                                                                                                110     1     112200 
                                                                                                2     100     110000 
                                                                                                4     110     112200     这样的，大家看的更清楚

Answer 1

insert into cateinfo select id,(select pid from cateinfo cc where cc.yid=si.father) , father from si