我做了一个全局作用域来获取列状态= 1的数据。它工作得很好。但是我在代码中遇到了这个问题，我不知道如何解决这个问题：
“留言”：“SQLSTATE[23000]：违反完整性约束：1052 where子句中的列”status“不明确（SQL：选择items .*，item_orders . order_id作为pivot_order_id，item_orders . item_id作为pivot_item_id，item_orders . quantity作为pivot_quantity从items内部连接item_orders到items . id = item_orders . item_id，其中item_orders . order_id = 1且status = 1 order by id desc）"，
下面是我的代码：

$order =  Order::find($id);

       if (is_null($order) || empty($order))
           return ResponseHelper::customizedResponse(false,'4500','No Order is available');

       $user =$order->user_id;

       $place = Place::where('id',$order->place_id)->first();

       $orderItems = ItemOrder::where('order_id',$order->id)->get()->toArray();

       $orderArray = [];
        $itemQ = [];
       foreach ($orderItems as $orderItem)
       {
           $orderArray[] =$orderItem['item_id'];
           $itemQ[] = $orderItem['quantity'];
       }

        $items = Item::whereIn('id',$orderArray)->get();

        $itemP = [];
        foreach ($items as $item)
        {
            $itemP[]= $item->price;
        }

        $totalItem = array_map(function ($price,$quantity){
            return $price * $quantity;
        },$itemP , $itemQ );

        $total = array_sum($totalItem);
        $customer = User::find($user);

        $address = Address::where('user_id',$customer->id)->first();

       return response()->json(['order'=>$order,'place'=>$place,'items'=>$items,'customer'=>$customer,'address'=>$address,'total'=>$total]);

字符串
全球范围：

public function apply(Builder $builder, Model $model)
    {
        if (str_contains(request()->route()->uri(),'api')) {

            $builder->where('status', '=', 1);
        }
    }

型