SELECT t2.user_id,t2.unit_id as unit_id,t1.first_name,t1.email_address as studemail,t1.emp_user as emp_email FROM wp_userinfo_tbl t1
LEft JOIN wp_user_assign_unit_tbl as t2 ON t1.user_id = t2.user_id
WHERE t1.user_type = 'student' AND t1.status = '1' AND t1.emp_user = 'testemp@testemp.com' AND t2.user_status = '1'
unit= sevendayleft red 1022
unit= 1022
unit= 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1022
unit= sevendayleft red 1317
unit= 1317