PHP程序循环迭代中谨慎操作数据库-PHP源码

/**
* 递归获取分类
* @author：xxx
* @param $tree_id
*/
function get_child_tree($tree_id = 0)
{
$three_arr = array();

$sql = “SELECT count(*) FROM TABLE WHERE parent_id = “$tree_id” AND is_show = 1 ";
if ($GLOBALS[db]->getOne($sql) || $tree_id == 0)
{
$child_sql = "SELECT ……";
$res = $GLOBALS[db]->getAll($child_sql);
foreach ($res AS $row)
{
if ($row[is_show])
{
$arr[id] = $row[cat_id];
……
}

if ( intval($row[cat_id]) != 0) {
$three_arr[$row[cat_id]][cat_id] = get_child_tree($row[cat_id]);
……
}
}
}
return $three_arr;
}