SELECT *
FROM `section`
INNER JOIN segment ON segment.id_section=section.id_section
INNER JOIN troncon ON troncon.id_segment =segment.id_segment 
INNER JOIN bief ON bief.id_bief=troncon.id_bief
WHERE `num_section`=106 OR num_section=107 OR num_section=127
GROUP BY bief.id_bief