select CONCAT(e.last_name,"'",e.first_name) as name from employees e

# 方法二 转义
# SELECT concat(last_name,'\'',first_name) AS name
# FROM employees;