Question

thinkphp 关联模型只有副表关联主表查询

thinkphp 里主project主表字段(id,name),副表project_sub字段(id,project_id,title),project_sub表的project_id保存的是project表的值，请问我在主表project循环的时候，怎样查询出project_sub的值呢？

Answer 1

不需要循环查询，做一次联表查询就可以了；
$data = M()->table('project a')->join('project_sub b on b.project_id = a.id')->field('a.id as aid, a.name, b.id as bid,b.title');