tp5链表查询

控制器

$schoolstation_rs=Db::name('school')

->field('a.id,a.title,b.sid,b.price')

->alias('a')

->join('schoolstation b','a.id = b.sid')

->where('a.pid',$rs['sid'])

->where('a.flid',2)

->select();

$this->assign('schoolstation_rs',$schoolstation_rs);

模板

2. {volist name="schoolstation_rs" id="schoolstation"}

4. {$schoolstation.title}