用两个concat即可

SELECT CONCAT(last_name,CONCAT("'",first_name)) as name
                               from employees;