type joinedUser struct { User user `xorm:"extends"` Friend friend `xorm:"extends"` } func (joinedUser) TableName() string { return "friends" } { jus := []joinedUser{} err = engine. Join("INNER", "users", "users.id = friends.friend_id"). Find(&jus) if err != nil { log.Println(err) return } }