thinkphp时间区域内查询

 $Model = new \Think\Model();

$sqlstr = 'SELECT b.district,count(a.centercode) as count from wx_archives a,wx_nation b WHERE a.centercode=b.code and a.step_status=9 and a.examine_status=1 and unix_timestamp(a.add_time) > '.strtotime($datebegin).' and unix_timestamp(a.add_time) < '.strtotime($dateend).' GROUP BY a.centercode ORDER BY count desc';

$data = $Model->query($sqlstr);