Tukukkk

I am having a problem about getting the value of table

LeaveRequest(id, leave_from_date, leave_to_date, leave_status)

When i want to add id of the leave_request into table Attendance using this condition.

Attendance(user_id, attendance_date, leave_id)

The query statement is

SELECT `attendances`.`attendance_date`,`leave_requests`.`user_id`,`leave_requests`.`leave_from_date`,`leave_requests`.`leave_to_date`,`leave_requests`.leave_status FROM `attendances`, `leave_requests` WHERE `attendances`.`user_id` = `leave_requests`.`user_id` AND `leave_requests`.`leave_status` = 2 AND `attendances`.`attendance_date` BETWEEN `leave_requests`.`leave_from_date` AND `leave_requests`.`leave_to_date` 

But when I insert this line into my current Attendance table

return $this->attendance()->create([

                'attendance_date' => Carbon::now()->format('Y-m-d'),

                'scan_in_time' => Carbon::now()->format('H:i:s'),

                'attendance_status' => DB::RAW("CASE

                WHEN scan_in_time >= '08:30:00' AND scan_in_time < '09:00:00' THEN '2'

                WHEN scan_in_time > '09:00:00' AND scan_in_time < '17:00:00' THEN '3' ELSE '1' END"),

                'scan_in_location' => request()->scan_in_location,

                'scan_in_remarks' => request()->scan_in_remarks,

                'leave_id' => DB::RAW("SELECT `leave_requests`.`id`

FROM `attendances`, `leave_requests`

WHERE `attendances`.`user_id` = `leave_requests`.`user_id`

AND `leave_requests`.`leave_status` = 2

AND `attendances`.`attendance_date` BETWEEN `leave_requests`.`leave_from_date` AND `leave_requests`.`leave_to_date`")

The value of leave_id is NULL in database. Is there anyway to improve this code so that leave_id is existed in Attendance table? Thank you