select user.id, user.name, user.zodiac, zodiac.id as zodiac_id, zodiac.name as zodiac_name from user inner join zodiac on zodiac.id = user.zodiac