ALTER TABLE `wa_wabinar_broadcaster` ADD `student_count` int(11) NOT NULL DEFAULT '0' AFTER `embed_chat`

UPDATE wa_wabinar_broadcaster wb SET wb.student_count = 
( 
    SELECT COUNT(DISTINCT(eps.student_id)) 
    FROM was_event_publisher_student eps
    WHERE eps.publisher_id = wb.user_id
)