SELECT `a`.*, `b`.`name`, `b`.`ic_no`, `b`.`birthdate`, `b`.`occupation`, `b`.`oku_status`, `b`.`study_status`, `c`.`action_efective_date`, `d`.`type`
FROM `user__pcb` `a`
JOIN `user__family_member` `b` ON `b`.`id` = `a`.`family_id` and `b`.`is_delete` = 0
LEFT JOIN `user__profiling` `c` ON `c`.`id` = `a`.`profiling_id`
LEFT JOIN `_ref__action_type` `d` ON `d`.`id` = `c`.`action_type_id`
WHERE `a`.`is_delete` =0
AND `a`.`user_id` = '3'