SELECT 
  c.company_id, 
  vp.vendor_store 
FROM 
  tconnect_companies as c 
  LEFT JOIN tconnect_vendor_plans as vp ON vp.plan_id = c.plan_id

Query time 0.00105

Result

company_id vendor_store
1 1
2 0