go-xorm-read-group-count

type countPerUserID struct {
	Count  uint
	UserID uint64
}

func (countPerUserID) TableName() string {
	return "friends"
}



{
	cpuis := []countPerUserID{}
	err = engine.
		Select("count(*) as count, user_id").
		Where("deleted_at IS NULL").
		GroupBy("user_id").
		Find(&cpuis)
	if err != nil {
		log.Println(err)
		return
	}
}

thanks for show this