Convert NULL value to empty string use 'IF' in 'SELECT' statement

SELECT id, 

      IF(o.office IS NULL ,'',o.office ) as office

FROM table