php 递归部门生成json数组

<?php
ini_set("error_reporting",E_ALL & ~E_NOTICE);

ListMenu();	
$list[] = array(); //传入数组

	function ListMenu()
	{
		$query = @mysql_query("select * from bpm_bumen where shangji_id=0 and panduan_shanchu=0") or die("SQL语句执行失败"); 
		while($row = mysql_fetch_array($query)) 
		{
		  $_id= $row['id'];
		  $_name=$row['name'];
//$list[] = array("code" => $_id,"codeName" => $_name,"status" => "1");

$gongliang.='{"code":"'.$_id.'","codeName":"'.$_name.'","status":"1"},';

$gongliang.=GetSubMenu($_id,0);
	}	
	//echo json_encode($list);
	 $json='['.rtrim($gongliang, ',').']';
	 echo json_decode(json_encode($json),true);
	}
	
	function GetSubMenu($_id,$num)
	{

//echo "select * from bpm_bumen where shangji_id='$_id' and panduan_shanchu=0";
//echo "<br>";

$num++;
$toadd='├'.str_repeat('─',$num);
//echo $num;
//echo "<br>8888888888888<br>";

//echo $toadd;
//echo $num;
//echo "<br>";
	
		$query = @mysql_query("select * from bpm_bumen where shangji_id='$_id' and panduan_shanchu=0") or die("SQL语句执行失败"); 
		while($row = mysql_fetch_array($query)) 
		{
			$bm_id= $row['id'];
			$bm_name=$row['name'];
//echo $toadd;
//$toadd .= "┴";
//$list[] = array("code" => $bm_id,"codeName" => $toadd.$bm_name,"status" => "1",);

$gongliang.='{"code":"'.$bm_id.'","codeName":"'.$toadd.$bm_name.'","status":"1"},';

$gongliang.=GetSubMenu($bm_id,$num);

//$toadd = $toadd.substr(0, strlen($toadd) - 1); 

//$toadd = substr(0, strlen($toadd) - 1); 
//$toadd = substr($toadd,0,2);

		}
		return $gongliang;
		//echo json_encode($list);
	}
?>

 

模板格式

 

 

我生成的格式

　　

最后效果呈现