SELECT t.*, c.*  FROM times t 
LEFT JOIN class_time_r ct ON ct.tid = t.tid 
LEFT JOIN class_user_r cu ON cu.cid = ct.cid 
LEFT JOIN classes c ON ct.cid = c.cid;