YII框架递归

Controller:

    public function actionWorkadd()
    {
        $sql="select * from work";
        $data=Yii::$app->db->createCommand($sql)->queryAll();
        //print_r($data);die;
        $option=nolimit($data,0);   //调用递归方法
        //print_r($option);die;
        return $this->renderPartial('workadd',['res'=>$option]);
    }

function nolimit($data,$p_id=0,$level=0){
        //加static防止覆盖上一次的
        static $arr=array();
        foreach($data as $v){
            if($v['p_id']==$p_id){
                $v['level']=$level;
                $arr[]=$v;
                $option=nolimit($data,$v['w_ids'],$level+1);
            }
        }
        //返回数据
        return $arr;
    }

view：

<select name="p_id">
                  <option value="0" selected>请选择...</option>
                  <?php foreach ($res as $k=>$v):?>
                  <option value="<?php echo $v['w_ids'] ?>"><?php echo str_repeat('&nbsp;&nbsp;',$v['level']*2).$v['w_names'] ;?></option>
                <?php endforeach;?>
  </select>

样式：

数据库样式：