SELECT mzs.xtitle,mzs.url,mzs.cid,procate.cname,procate.curl FROM mat_mzs mzs LEFT JOIN mat_procate procate ON mzs.cid = procate.id WHERE mzs.id IN ()