Question

thinkphp关联模型的时候sql语句有问题

查询出来的数据是空的。而且sql语句中的条件也为空
<?php
namespace Home\Model;
use Think\Model\RelationModel;

class UserModel extends RelationModel{

//联表
protected $_link = array(
'talk' =>array(
'mapping_type' =>self::HAS_MANY ,
'foreign_key' =>'userID',
),
);
}

<?php
namespace Home\Controller;
use Think\Controller;
class UserController extends Controller {
public function a(){
$user = D('user');
$data = $user->relation(true)->select();
dump($data);
}

//输出
array (size=4)
'userid' => string '1' (length=1)
'username' => string '123' (length=3)
'userpassword' => string '123' (length=3)
'talk' =>
array (size=0)
empty

Answer 1

你这个属于一对一关系，要用HAS_ONE