MySQL Proxy on Current User
I found the answer to be,

CASE (SELECT RoleType FROM user)
    WHEN 'standard' THEN
        GRANT PROXY ON 'standard_user'@'localhost' TO CURRENT_USER();
    WHEN 'admin' THEN
        GRANT PROXY ON 'admin_user'@'localhost' TO CURRENT_USER();
END CASE;