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