QueryBuilder - используйте Select во innerJoin

Кто-нибудь может мне помочь. Мне нужно изменить свой sql-запрос на построитель запросов. Я не знаю, как использовать select внутри innerJoin.

Вот мой запрос sql:

SELECT 
      user.id,
      analytic_youtube_demographic.age_group, 
      analytic_youtube_demographic.percentage
FROM 
    user
INNER JOIN user_youtube ON user_youtube.id = user.id
INNER JOIN analytic ON analytic.id = user_youtube.analytic_id
INNER JOIN analytic_youtube_demographic ON analytic_youtube_demographic.analytic_id = analytic.id
INNER JOIN 
(
SELECT analytic_youtube_demographic.id as id, MAX(analytic_youtube_demographic.percentage) max
from user
INNER JOIN user_youtube ON user_youtube.id = user.id
INNER JOIN analytic ON analytic.id = user_youtube.analytic_id
INNER JOIN analytic_youtube_demographic ON analytic_youtube_demographic.analytic_id = analytic.id
GROUP BY user.id
) AS T ON analytic_youtube_demographic.percentage = T.max
WHERE analytic_youtube_demographic.age_group IN ('18-24')

Большое спасибо за твою помощь.