Why do you need a WHILE loop?
WITH STUDENTS AS (

    SELECT 'Student1' AS StudentName UNION ALL
    SELECT 'Student2'
)
SELECT R.RoomName, S.StudentName
FROM STUDENTS AS S
    CROSS APPLY (VALUES ('Room1'), ('Room2'), ('Room3')) AS R (RoomName)
ORDER BY S.StudentName, R.RoomName;