你可以用表达式而不是语句。
select email, cast((select tag from user_tags where userid=users.id limit 1) as date) as date from users