Recursive query in Laravel

<?php/** * Created by PhpStorm. * User: Zafar Hayat * Date: 6/26/2020 * Time: 7:06 PM */
namespace App\Services;
use Illuminate\Support\Facades\DB;
class FileWithDeepSearch{    /**     * @var PHPFunction     */    private $PHPFunction;    /**     * @var Common     */    private $common;    /**     * @var Filters     */    private $filters;
    public function __construct(        PHPFunction $PHPFunction,        Common $common,        Filters $filters    ) {        $this->PHPFunction = $PHPFunction;        $this->common = $common;        $this->filters = $filters;    }
    public function getQuery(array $data)    {        $currentDirectoryFilesQuery = $this->getCurrentDirectoryFilesQuery($data);        $recursiveQuery = $this->getRecursiveQuery($data);        $recursiveQuery = $recursiveQuery->unionAll($currentDirectoryFilesQuery);        return $recursiveQuery;    }
    private function getCurrentDirectoryFilesQuery(array $data)    {        $q = DB::table('files_directories as fd')            ->select('f.id', 'f.name', 'f.created_by', 'f.created_at', 'f.updated_at', 'f.file_type', 'f.file_size', 'f.business_date', 'fd.ref_id')            ->selectRaw("1 as is_file")            ->join('files as f', 'f.id', 'fd.file_id')            ->whereRaw($this->common->applyWhere('fd.directory_id', $data['folder_id']))            ->whereRaw('fd.is_current = true');
        $this->filters->applyBusinessDateRangeFilter($q, $data);
        return $q;    }
    public function getRecursiveQuery(array $data)    {        $query = DB::table('directories')            ->select('id', 'name', 'parent_id')            ->whereRaw($this->common->applyWhere('parent_id', $data['folder_id']))            ->unionAll(                DB::table('directories  as d')                    ->select('d.id', 'd.name', 'd.parent_id')                    ->join('tree', 'tree.id', '=', 'd.parent_id')            );
        $builder = new \Staudenmeir\LaravelCte\Query\Builder(app('db')->connection());

        $builder->from('tree')            ->select('f.id', 'f.name', 'f.created_by', 'f.created_at', 'f.updated_at', 'f.file_type', 'f.file_size', 'f.business_date', 'fd.ref_id')            ->selectRaw("1 as is_file")            ->withRecursiveExpression('tree', $query)            ->join('files_directories as fd', 'fd.directory_id', 'tree.id')            ->join('files as f', 'fd.file_id', 'f.id')            ->whereRaw('fd.is_current = true');
        $this->filters->applyBusinessDateRangeFilter($builder, $data);
        return $builder;    }}