最新充值的用户

SELECT FROM_UNIXTIME(b.operate_time/1000,('%Y-%m-%d %H:%i:%S'))  AS '充值时间',a.`user_id` AS '用户ID',a.`user_name` AS '用户名',b.amount/1e8 AS '充值金额',c.times AS '充值次数',a.`telephone` AS '电话',a.`email` AS '邮箱',a.`country_id` AS '国家代码' FROM 
`management`.`t_trade_user` AS a,
(SELECT user_id,amount,operate_time FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=1) AS b,
(SELECT user_id,COUNT(1) AS 'times' FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=1 GROUP BY user_id) AS c
WHERE a.`user_id`=b.user_id AND a.`user_id`=c.`user_id` AND `country_code`=86 AND a.`telephone` IS NOT NULL ORDER BY b.operate_time DESC LIMIT ${limit};