select u.u_nick,u.u_tel,u.u_qq, u.u_ctime,a.total from c_user as u 
inner join (SELECT a_sid as uid,count(*) as total from a_saction where a_ctime> '2021-06-01' and a_ctime < '2021-12-30' GROUP BY a_sid ) a
 on a.uid = u.u_id