sql - 你能帮我如何为每个订单添加价格*数量吗？在我的查询中，它只显示单独的订单价格

Question

$purchasers = DB::table('orders')
                ->join('users as buyers', 'buyers.user_id', '=', 'orders.user_id')
                ->join('order_items','order_items.order_id','=','orders.order_id')
                ->join('stocks','stocks.stock_id','=','order_items.stock_id')
                ->join('sizes','sizes.size_id','=','stocks.size_id')
                ->join('shoes','shoes.shoe_id','=','stocks.shoe_id')
                ->where('orders.status', '2')
                ->where('orders.completed_date', '>=', $start)
                ->where('orders.completed_date', '<=', $end)
                ->select(DB::raw('CONCAT(buyers.last_name, ", ", buyers.first_name) as user_fullName'),DB::raw('order_items.quantity * shoes.price as amount'),
                'orders.order_id as order_id' )

标签： sqllaravelgroup-bysumsql-order-by