namespace Admin\Model;
use Think\Model\RelationModel;
class AccessModel extends RelationModel{
protected $_link = array(
'user'=>array(
'mapping_type' => HAS_ONE,
'class_name' => 'user',
'mapping_name' => 'user',
'foreign_key' => 'group_id',
),
);
}aacces为主表,user是附表,user表中有个字段group_id等于aacces表中的ID,一对一对应。执行方法如下:
$Aacces = D('Access');
$list = $Access->where('id='.$id)->relation(true)->select(false);
dump($list);打印结果是:SELECT * FROM `ls_aacces ` WHERE ( id=5 ) 最佳答案