1. SELECt U.email, A.client_id, A.trade_volume, A.taker_fee, A.maker_fee, A.created_at FROM affiliate.t_daily_trade as A left join management.t_trade_user as U on U.user_id = A.client_id WHERE client_id IN ( select invitee FROM t_invitation where affiliate.inviter =8643758590)