php - Laravel Raw Statement Where I can select from different table based on if a column data is equal to another

one text

Solution:

Try this query -

public function collection()
{
    return DB::table('bookings')->select(
        'id',
        'place_id',
        'payer_name',
        'user_fullname',
        'user_email',
        'user_phone',
        'user_no_of_guest',
        'user_no_of_babies',
        'user_checkin',
        'user_checkout',
        'is_approved',
        'user_promo',
        'user_payment_type',
        'user_booking_tracking_id',
        Booking::raw('(created_at +  INTERVAL 2 HOUR) AS created_at'),
        'paid_ammount',
        'promo_codes.promo_type'
    )->join('promo_codes', 'booking.user_promo', '=', 'promo_codes.promocode')->get();
}