不需要循环查询,做一次联表查询就可以了;$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');