laravel 获取多上级和多下级节点

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use App\Models\Node;

class NodeController extends Controller
{
    public function item($alias)
    {
        $node = Node::where(['alias'=>$alias])->first();
        $node->parents = Node::where(['status'=>'1'])->whereIn('id',$node->parent_ids)->get();
        $nid = $node->id;
        $node->childs = Node::where(function ($query) use ($nid) {
                  $query->whereRaw("FIND_IN_SET($nid,parent_ids)");
              })->orderBy('created_at','DESC')->get();

        return view('node.node_item',compact('node'));
    }
}