SELECT cc.id, cc.customer_id, cc.first_name, cc.last_name, cc.email, cc.phone, cc.position, cc.is_primary, cc.created_at
   FROM customer_contacts cc
   LEFT JOIN customers c ON cc.customer_id = c.id