SELECT 
  c.company_id, 
  vp.vendor_store 
FROM 
  cscart_companies as c 
  LEFT JOIN cscart_vendor_plans as vp ON vp.plan_id = c.plan_id