select top 50 id,foldername from ks_class where ID in({$CurrClassChildID}) and tj <=(select tj+1 as ctj from ks_class where id='{$CurrClassID}') order by folderorder

没测试，若不行，再留言 看到后 再帮你修改下