```
應用:當a(新聞表)表的類別與b(類別表)表的id相等時,
查詢出a(新聞表)表的所有信息和b(類別表)表的所有信息
$news = Db::name("news")
->field("b.title as category_name,a.*")//查出a的所有,b的title取名 category_name
->alias("a") //news表名取別名a
->leftJoin("category b","a.category=b.id") //category表名取b,條件:a.category=b.id
->where($where) //條件
->order("a.id","desc")
->paginate($pageSize,false,["query"=>$pagecon]);
```
對應的sql:
` SELECT a.*,b.id FROM jxwlrl_news a inner JOIN jxwlrl_category b on a.category=b.id`