无限极格式化数据（测试）

<?php

$conn = mysql_connect('localhost:3306','root','') or die('数据库服务器连接失败');

 mysql_query('use dbname',$conn) or die('数据库连接失败');
 mysql_query('set names utf8');
 $sql = 'select * from tablename';
 $res = mysql_query($sql);
 while($row = mysql_fetch_assoc($res)){
     $rows[] = $row;
 }
 $result = tree($rows);


 function tree($data,$parent=0,$level=0){
     static $tree = array();
     $children = array();
     unset($v);
     foreach($data as $k=>$v){
         if($v['pid'] == $parent){
             $v['level'] = $level;
             $tree[] = $v;
             tree($data,$v['id'],$level+1);
         }
     }
     return $tree;
 }
 ?>
 <select>
 <?php unset($v);?>
 <?php foreach($result as $k=>$v):?>
 <option><?php echo str_repeat("&nbsp;&nbsp;",$v['level']*1),$v['text']?></option>
 <?php endforeach;?>
 </select>