Get users from DB filtered by a checkbox user field

custom_query.sql

SELECT 
    u.ID as UserID,
    u.user_login as Username,
    u.user_email as Email,
    u.user_registered as RegisteredDate,
    um.meta_value as CommitteeMemberStatus
FROM 
    wp_users u
JOIN 
    wp_usermeta um 
    ON u.ID = um.user_id
WHERE 
    um.meta_key = 'committee_member'
    AND um.meta_value = '1'
ORDER BY 
    u.user_registered DESC;