首页 > 代码库 > 数据库数据变成树型结构

数据库数据变成树型结构

<?php$arrData= http://www.mamicode.com/array("id" => "1",		"pid" => "0",		"name" => "山东"	),	array(		"id" => "2",		"pid" => "0",		"name" => "云南"	),	array(		"id" => "3",		"pid" => "1",		"name" => "济南"	),	array(		"id" => "4",		"pid" => "2",		"name" => "大理"	),	array(		"id" => "7",		"pid" => "3",		"name" => "历下区"	),	array(		"id" => "8",		"pid" => "7",		"name" => "大明湖"	),	array(		"id" => "9",		"pid" => "1",		"name" => "青岛"	),	array(		"id" => "10",		"pid" => "3",		"name" => "**县"	),);$arrReData = http://www.mamicode.com/array();"id"]] = $data;	if($data["pid"]!="0" && isset($arrReData[$data["pid"]])){		if(!isset($arrReData[$data["pid"]]["children"])){			$arrReData[$data["pid"]]["children"] = array();		}		$arrReData[$data["pid"]]["children"][] = &$arrReData[$data["id"]];	}else{		$result[] = &$arrReData[$data["id"]];	}}print_r($result);
Array(    [0] => Array        (            [id] => 1            [pid] => 0            [name] => 山东            [children] => Array                (                    [0] => Array                        (                            [id] => 3                            [pid] => 1                            [name] => 济南                            [children] => Array                                (                                    [0] => Array                                        (                                            [id] => 7                                            [pid] => 3                                            [name] => 历下区                                            [children] => Array                                                (                                                    [0] => Array                                                        (                                                            [id] => 8                                                            [pid] => 7                                                            [name] => 大明湖                                                        )                                                )                                        )                                    [1] => Array                                        (                                            [id] => 10                                            [pid] => 3                                            [name] => **县                                        )                                )                        )                    [1] => Array                        (                            [id] => 9                            [pid] => 1                            [name] => 青岛                        )                )        )    [1] => Array        (            [id] => 2            [pid] => 0            [name] => 云南            [children] => Array                (                    [0] => Array                        (                            [id] => 4                            [pid] => 2                            [name] => 大理                        )                )        ))

  

数据库数据变成树型结构