尝试一下.

$clients = Client::join('users as manager', 'manager.id','=','clients.manager')
            ->orderBy('manager.name', $order)
            ->select('clients.*') // avoid fetching anything from joined table
            ->with('Manager');  // if you need managers data anyway

将其放入您的if语句if($sort == 'contact'){ /***/ }

Put this into your if statement if($sort == 'contact'){ /***/ }