how can add two fields name in one fields in mysql Exp : Id, email= id+name

select id,email from email
output:
id  email
1  test@gmail.com
2  demo@gmail.com


select CONCAT(id,'--->',email) as test from email
output: 
test
1--->test@gmail.com
2--->demo@gmail.com