递归获取文件夹id下所有子文件夹id和文件id

/**
 * 查询文件夹下的文件及文件夹
 */
 为了实现删除文件夹功能，写了这个方法，可以递归获取文件夹id下所有子文件夹id和文件id

public function getFileFolderIds($folder_id,$totals=[]){
    $total = $totals;
    if(is_array($folder_id)){
        $folder_id = implode(",", $folder_id);
            $sql1 = "SELECT id FROM yy_folder WHERE id in (".$folder_id.")" ;
            $sql2 = "SELECT id FROM yy_file WHERE folder_id in (".$folder_id .")";
            $file_ids = $this->db->query($sql1);
            foreach ($file_ids as $vv){
                $total["file_ids"][] = $vv;
            }
            $folder_ids = $this->db->query($sql2);
            foreach ($file_ids as $vvv){
                $total["folder_ids"][] = $vvv;
            }
            if($folder_ids){
                return  $this -> getFileFolderIds($folder_ids,$total);
            }else{
                return $total;
            }

    }else{