用户配资

SELECT FROM_UNIXTIME(a.insert_time/1000,('%Y-%m-%d %H:%i:%S'))  AS '配资时间',a.client_id AS '用户ID',b.`user_name` AS '用户名',b.`telephone` AS '电话',b.`email` AS '邮箱',a.fund_value AS '配资金额' 
FROM `management`.`t_with_funding` AS a,
`management`.`t_trade_user` AS b
WHERE a.`client_id`=b.user_id AND b.`country_code`=86 ORDER BY a.insert_time DESC;