07thinkphp TP mysql join使用

public function lst(Request $request,int $cid){// dump($cid);// 根据cid查tb_spu表,cid3字段 = $cid// 需要执行的sql语句如下#  select * from tb_spu as p join tb_sku as k on p.id = k.spu_id limit 10;$spus = Db::table('tb_spu')->alias('p')->where('cid3',$cid)->join('tb_sku k','p.id = k.spu_id')->paginate(10); //返回一个对象类型// $page = $spus->render();#将一个tp查询结果集collection对象转换为数组// dump($spus->toArray());return view('lst',['spus'=>$spus]);}