select one.*,tw.id sid,tw.catlevel slevel,tw.name sname,tw.code scode,thr.id    tid,thr.catlevel tlevel,thr.name as tname, thr.code as tcode     from tb_sort    one join tb_sort tw on tw.pid=one.id join tb_sort thr on thr.pid=tw.id    order by one.order1,tw.order1,thr.order1
         
          
          
          
          
              
               
               
               
               
                   
                    
                    
                    
                
           
      
     

实体类接收数据：

private List
     
       children;