select a.user_id,mission,a.cc count_order,date from (select user_id,count(1) cc,DATE_FORMAT(FROM_UNIXTIME(order_time),'%Y-%m') odr_mn from order group by user_id, odr_mn) a join task b on a.user_id=b.user_id and a.odr_mn=DATE_FORMAT(FROM_UNIXTIME(b.date),'%Y-%m');