查询是:

SELECT * FROM startups where id IN (
     SELECT startups.id as id 
     FROM startups startups 
     INNER JOIN funds ON  startups.id=funds.startup_id 
     INNER JOIN ( 
         SELECT funds.startup_id, MAX(funds.id) as maxid 
         FROM funds 
         GROUP BY funds.startup_id 
     ) f ON funds.id = f.maxid 
         AND funds.startup_id = f.startup_id
     where fund_type="Series B")

事情是内部连接已经在laravel中的两个表之间完成,并且在连接时我必须在'IN'之后以Eloquent查询的形式包含sql部分 . 请帮忙 .