SELECT loan_applications.province_id AS province_id,
loan_applications.branch AS branch,
loans.id AS loanid,
loans.client_id,
loans.loan_application_id,
loan_applications.disbursement_date AS disbdate,
loan_applications.disbursed_amount AS disbamt,
loans.term_period,
loan_applications.current_loan_place AS loancycle,
loans.last_repayment_date AS maturitydate,
clients.dob,
JSON_EXTRACT (loan_question_data.input_data, '$.gender') AS gender,
JSON_EXTRACT (loan_question_data.input_data, '$.martial_status') AS martial,
JSON_EXTRACT (loan_question_data.input_data, '$.education') AS education,
loan_repayment_schedule.status,
loan_repayment_schedule.remain_balance,
loan_repayment_schedule.period,
loan_repayment_schedule.repayment_date,
loan_repayment_schedule.updated_at
FROM
loans
JOIN loan_applications ON loans.loan_application_id = loan_applications.id
JOIN clients ON loans.client_id = clients.id
JOIN loan_question_data ON loan_applications.id = loan_question_data.id
JOIN loan_repayment_schedule ON loans.id = loan_repayment_schedule.loan_id
WHERE
loans.created_at BETWEEN '2024-05-01' AND '2024-05-31';

This current query that joined loans table and loan_repayment_schedule table.The result is –

but in the loan_repayment_schedule table, the status and repayment date is not same.

How can I correct these data ?