SELECT `a`.*, `b`.`name` as `type`
FROM `hr__leave_allocation_request` `a`
JOIN `hr__leave_type` `b` ON `a`.`type_id` = `b`.`id`
WHERE `a`.`is_delete` =0
AND `user_id` = '23'
AND `year` = '2019'