mysql语句

$sql = "SELECT LEFT(FROM_UNIXTIME(data_ucenter_member.reg_time),10) as mergetime,count(data_ucenter_member.id) as new_uid,pay1.new_pid,od1.new_rid FROM `data_ucenter_member` left join ( select count( pay.id) as new_pid ,order_time from  data_pay as pay  group by LEFT(order_time,10) ) as pay1  on LEFT(FROM_UNIXTIME(data_ucenter_member.reg_time),10) = LEFT(pay1.order_time,10) left join ( select count(id) as new_rid , order_time from data_order group by LEFT(order_time,10) ) as od1  on LEFT(FROM_UNIXTIME(data_ucenter_member.reg_time),10) = LEFT(od1.order_time,10) GROUP BY LEFT(FROM_UNIXTIME(data_ucenter_member.reg_time),10) ORDER BY data_ucenter_member.reg_time desc";