SELECT
*,
baseline_information.*,
ujwala_scheme_details.*,
project_details.*,
project_details.id AS project_id
FROM
beneficiaries
LEFT JOIN
baseline_information ON beneficiaries.id = baseline_information.beneficiary_id
LEFT JOIN
ujwala_scheme_details ON beneficiaries.id = ujwala_scheme_details.beneficiary_id
LEFT JOIN
project_details ON beneficiaries.id = project_details.beneficiary_id
WHERE
beneficiaries.id =11648