模型

namespace app\common\model;
use think\Model;
class Order extends Model
{
public function goods(){
return $this->belongsTo(‘goods’,‘gid’,‘id’)->bind(‘goodsname’);
}
}

控制器

$data=model{(}^{\prime }orde{r}^{\prime })->with{(}^{\prime }good{s}^{\prime })->field{(}^{\prime }addtime,totalprice,ispay,status,hexiao,hexiaostatu{s}^{\prime })->order{(}^{\prime }iddes{c}^{\prime })->where($where)->select();
field这样写 查询的结果没有goodsname

$data=model{(}^{\prime }orde{r}^{\prime })->with{(}^{\prime }good{s}^{\prime })->field{(}^{\prime }addtime,totalprice,ispay,status,hexiao,hexiaostatus,goodsnam{e}^{\prime })->order{(}^{\prime }iddes{c}^{\prime })->where($where)->select();
$data=model{(}^{\prime }orde{r}^{\prime })->with{(}^{\prime }good{s}^{\prime })->field{(}^{\prime }gid,addtime,totalprice,ispay,status,hexiao,hexiaostatus,goodsnam{e}^{\prime })->order{(}^{\prime }iddes{c}^{\prime })->where($where)->select();
这两种field这样写 报错 Column not found: 1054 Unknown column ‘goodsname’ in ‘field list’ 查不到goodsname

正确的写法：
$data=model{(}^{\prime }orde{r}^{\prime })->field{(}^{\prime }gid,addtime,totalprice,ispay,status,hexiao,hexiaostatu{s}^{\prime })->with{(}^{\prime }good{s}^{\prime })->order{(}^{\prime }iddes{c}^{\prime })->where($where)->select();
也就是说：field 应在with关联预载入之前调用,并且要把关联的条件字段(gid)加进去,否则关联不上.