<?php
namespace Admin\Model;
// use Think\Model\RelationModel;
use Think\Model\ViewModel;
class GoodsModel extends ViewModel{
Protected $tableName ='Goods';
public $viewFields=array(
'Goods'=>array('gid','shopid','cid','lid','main_title','sub_title','price','old_price','buy','goods_img','_type'=>'LEFT'),
'category' => array(
// 'type' => 'inner',
'title'=>'category',
'_on' => 'category.cid=goods.cid',
),
'locality' => array(
// 'type' =>'inner',
'title'=>'locality',
'_on' =>'locality.lid=goods.lid'
),
'shop' => array(
// 'type' =>'inner',
'title'=>'shop',
'_on' =>'shop.shopid=goods.shopid'
),
);
/**
获取全部商品
**/
Public function getgoodsAll(){
echo $this->fetchSql(true)->select();
}
}创建了一个视图模型，无法进行关联 ，表结构如下 
最佳答案
