PHP 获取栏目的【所有子级和孙级栏目】的ID号

//@获取子栏目ID号
private function sonCategoryIds($categoryID)
{
    //@初始化栏目数组
    $array[] = $categoryID;
    
    do
    {
        $ids = '';
        $temp = $this->mysql->select('SELECT `id` FROM `pcb_article_category` WHERE `parentID` IN (' . $categoryID . ')');
        foreach ($temp as $v)
        {
            $array[] = $v['id'];
            $ids .= ',' . $v['id'];
        }
        $ids = substr($ids, 1, strlen($ids));
        $categoryID = $ids;
    }
    while (!empty($temp));
    $ids = implode(',', $array);
    
    return $ids;
}
点赞