Question

thinkPHP双表查询转换为join的写法

thinkPHP双表查询转换为join的写法
$count= $this->join('__USER__ ON __COMMENT__.uid=__USER__.id')
->field('__COMMENT__.id,__COMMENT__.content,__COMMENT__.create,__COMMENT__.uid,__USER__.username,__USER__.domain')
->order('__COMMENT__.create DESC')
->where('__COMMENT__.tid='.$tid)
->count();

哪里错了?

Answer 1

$Model->table('__COMMENT__ a')
    ->join('__USER__ b on a.uid=b.id')
    ->field('a.id,a.content,a.create,a.uid,b.username,b.domain')
    ->where('a.tid='.$tid)
    ->order('a.create DESC')
    ->count();