活动与活动报名关联检索

  $m=M();
  $wherestr['SUBMIT_UID'] =  $_COOKIE["member_user_id"];
  $wherestr['ACTIVIIES_ID'] = array("exp","is not null");




  $activiies_id_list=$m->table("M_T_U_ENLIST")->field("activiies_id")->where($wherestr)->group("activiies_id")->select();
  $aid_list = array();
  foreach($activiies_id_list as $key=>$value){
  $aid_list[]=$value["ACTIVIIES_ID"];
  }
  $aid_liststr = implode(',',$aid_list);



  $map['ACTIVITIES_STATUSS'] = array('EQ',"0");
  $map['AUDIT_STATUSS'] = array('EQ',"1");
  $map['ID'] = array("exp","in ($aid_liststr)");

 
 
  $model = D ( "Huodong" );
  $count = $model->where ( $map )->count ( $model->getPk () );