MySQL Trigger or Event Scheduler

I have 4 tables
a) Clients details table : m_client
b) Loan details table : m_loan
c) Loan transactions details table : m_loan_transaction
d) Message Out table :
I want to select details from Clients and loans table then insert into MessageOut table using a trigger or event scheduler below is my select query
SELECT
mc.mobile_no AS 'Phone Number',
CONCAT (mc.display_name, mlt.amount ) AS 'msg'

FROM m_loan_transaction mlt
INNER JOIN m_loan ml ON ml.id = mlt.loan_id
INNER JOIN m_client mc ON mc.id = ml.client_id

Below is sample code to insert data in message table
INSERT INTO ozekimessageout (receiver, msg, status) VALUES ('+36209355418', 'details', 'send');

I have attached sample database