function ListChildTree($SearchPattern,$BaseNum){ global $Tree;//声明连接数据库的句柄为全局 $Sql="select DepartmentId,DepartmentName from test where DepartmentId like '$SearchPattern'"; //查找孩子节点 $QueryChild=$Tree->query($Sql); while($Result=$Tree->fetch_array($QueryChild)) { //取出孩子节点 $Space=""; for($j=0;$j<((strlen($SearchPattern)/3)-$BaseNum);$j++) $Space.=" "; //设置显示节点前面的距离,这里的空格的html被这里自动替换成" "了 $ChildDepartment=trim($Result[0])."___"; $ChildSql="select count(*) from test where DepartmentId like '$ChildDepartment'";//查找孩子节点的孩子节点