子查询

select people from people where CityID =(select CityID from S_City where CityName like '%北京%') and goupId=(select goupId from goup where goupName like '%专家%')