//支持连表查询，也支持单表查询
$news = M("cms_news");
$news->table = 'se_cms_news as n left join se_user as u on n.uid=u.id';
$news->field = 'n.id,n.title,n.addtime,u.nickname,u.photo';
$news->where(['n.id' => ['NOT IN', [1, 2, 3]]]);
$news->where(['n.status' => 1]);
$news->orWhere(['n.title' => ['LIKE', '%AI%'], 'smallmemo' => ['LIKE', '%AI%']]);
$news->orderby(['n.id' => 'asc']);

$news->limit = '10,15';//getList不可用，因为有分页需求请注释

//每页10条数据
$news->pageSize = 10;
//或者调用pageSize方法赋值
$news->pageSize(10);

$news->isAjax = 1;//开启Ajax分页
$news->AjaxName = 'newsAjax';//和isAjax组合，用ajax分页，AjaxName是JS分页的method
$news->cache = 3600;//使用缓存，3600秒

$objAry = $news->getList();


也可以连贯写法：
$news = M("cms_news");
$news->table = 'se_cms_news as n left join se_user as u on n.uid=u.id';
$news->field = 'n.id,n.title,n.addtime,u.nickname,u.photo';
$news->where(['n.id' => ['NOT IN', [1, 2, 3]]])->where(['n.status' => 1])->orderby(['n.id' => 'asc'])->getList();