How to get all subcategories under a category in php_php cache file writing

<?php
static function getMenuTree($arrCat, $parent_id = 0, $level = 0,$all=True)
{
static $arrTree; //Use static instead of global
if(!$ all) $arrTree = '';
if(empty($arrCat)) return FALSE;
$level++;
if($level == 1) $arrTree[] = $parent_id;
foreach($arrCat as $key = > $value)
{
if ($value['parent_cid' ] == $parent_id)
{
//$value[ 'level'] = $level;
$arrTree[] = $value['cid' ];
unset($arrCat[$key]); //Unregister the current node data and reduce useless traversal
self::getMenuTree($arrCat, $value[ 'cid'], $level);
} // www.plcxue.com
}
return $arrTree;
}

Using the above method, you need to write the classification into the php cache file.

2. Cache file writing method:

public function actionIndex2()
{
$filepath = Yii::getPathOfAlias('application'). '/data/';
$arr = array();
$db = Yii::app()->db;
$listinfo = $db->createCommand("select name,cid,parent_cid,root_cid from item_cat_info")->queryAll();
foreach($listinfo as $val)
{
$arr[$val['cid']] = array('cid'=>$val['cid'], 'name'=>$val['name'],'parent_cid'=>$val['parent_cid'],'root_cid'=>$val['root_cid']);
}
$applist = " <?phpnreturn ".var_export($arr, true). ";n?>";
file_put_contents($filepath.'itemcat.php', $applist);
}