请教个一DB查询语句

$result = Order::query()->where('order.order_type', '<>', '取消')->join('order_details', 'order.id', '=', 'order_details.order_id')->get();

whereNotIn(‘order_id’,$orderIds) 这还怎么 join

order_type 类型建议用 tinyint

DB::table('order_details')->join("order","order.id","=","order_details.order_id")
            ->where("order.order_type","!=","取消")
            ->select([
                "order_details.*"
            ])->get();


            DB::table('order_details')
 ->whereRaw("exists(select id from order where order.id = order_details.order_id and order.order_type != '取消')")
 ->get();

没明白为什么要用\DB

这个应该用 关联模型里 基于存在的查询

// 强烈建议使用子查询
$result = OrderDetail::query()->whereNotIn('order_id', Order::query()->where('order_type','取消')->select('id'))->get();

嫌弃，order_type还用中文

    $datas = $brandModel->from('主表名 AS br')
            ->leftjoin('附表名 AS st', 'br.create_user', '=', 'st.staff_id')
            ->where('br.id', $parameters['id'])
            ->select('br.id', 'br.titles', 'br.created_at', 'br.create_user', 'st.staff_name')
            ->first()
            ->toArray();