sql在表添加字段别名,视添加字段sql语句

SELECT uf.fans_id as fansId,u.`nickname` as nickname,u.`head` as head, uf.`create_time` as createTime,1 as type FROM `user_fans` uf LEFT JOIN `user` u ON uf.fans_id=u.id WHERE uf.`user_id`=37 and enable=1