select id, email, phone, name, representative, source, franchisee, franchisee_id
from users where type = 'Customer'