SELECT * FROM mat_mzs mzs LEFT JOIN mat_p2s p2s ON mzs.id = p2s.proid WHERE mzs.id IN () AND p2s.id IN ()