select DATE_FORMAT(createdAt,"%d-%m-%Y")  as last_debited_date,amount as last_debited_amount,
available_balance as credit_limit,
(SELECT company_name from users where id=3) as company_name,
(select total_amount from flight_bookings where user_id=3 order by createdAt desc limit 0,1) as last_transaction_amount,
(select DATE_FORMAT(createdAt,"%d-%m-%Y") from flight_bookings where user_id=3 order by createdAt desc limit 0,1) as  last_transaction_date 
from accounts where share_by_user_id=2 and share_to_user_id=3 order by createdAt DESC limit 0,1