select new com.school.util.modle.ActivityModel(a.a_id as a_id ,a.a_title as a_title ,a.a_status as a_status,(select count(au.a_id) from ActivityUser au where au.a_id=a.a_id)as count)from Activity a where a.community.c_id="+cId+" order by a.a_status