Laravel如何查询收款？

// 定义Payment模型
namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Payment extends Model
{
    protected $table = 'payments';
    protected $fillable = ['amount', 'payment_date', 'user_id'];
}

// 在控制器中查询收款信息
use App\Models\Payment;

class PaymentController extends Controller
{
    public function getPaymentsByUser($userId, $startDate, $endDate)
    {
        // 查询特定用户在特定时间段内的所有收款记录
        $payments = Payment::where('user_id', $userId)
                            ->whereBetween('payment_date', [$startDate, $endDate])
                            ->get();

        // 计算总金额
        $totalAmount = $payments->sum('amount');

        return response()->json([
            'payments' => $payments,
            'totalAmount' => $totalAmount
        ]);
    }
}