重点:$query->withTrashed();

$info = self::with('userInfo', 'express.company')
            ->with(['product' => function ($query) {
                $query->withTrashed();
            }])
            ->where($where)
            ->select(['id', 'type', 'user_id', 'order_sn', 'membership_card_type', 'membership_card_id',
                'membership_card_info', 'membership_card_offer_fee', 'coupon_id', 'coupon_info', 'coupon_offer_fee',
                'original_price', 'delivery_fee', 'pay_type', 'price', 'remarks', 'status', 'extend_info', 'created_at'])
            ->orderBy('id', 'desc')
            ->first();