Solr nested join

Question

select * from people
inner join submissions on people.id = submissions.person_id
inner join stage_transitions on submissions.id = stage_transitions.id
where stage_transitions.stage = 'lead'

I want to convert this sql query into solr query