GORM关联查询使用请教

type UserInfo struct {
    ID       uint       `json:"id" msgpack:"id" gorm:"primary_key"`
    Email    string     `json:"email" msgpack:"email" gorm:"unique" `
    Nickname string     `json:"nickname" msgpack:"nickname" gorm:"unique" `
    Profile  string     `json:"profile" msgpack:"profile"`
    Icons    []UserIcon `json:"icons" msgpack:"icons" gorm:"foreignKey:user_id;localKey:id;comment:头像列表"`
}

func (u UserInfo) TableName() string {
    return "tz_user"
}

type UserIcon struct {
    BaseModel
    UserId     uint      `json:"user_id" msgpack:"user_id" gorm:"comment:用户id"`         //用户
    AssetId    uint      `json:"asset_id" msgpack:"asset_id" gorm:"comment:资源id"`       //资源
    IsActivity int8      `json:"is_activity" msgpack:"is_activity" gorm:"comment:是否启用"` //激活状态，1为当前使用中的头像
    Asset      Asset     `json:"asset" msgpack:"asset" gorm:"foreignKey:id;localKey:asset_id;comment:关联资源"`
    UserInfo   *UserInfo `json:"user_info" msgpack:"user_info" gorm:"foreignKey:user_id;localKey:id;comment:用户信息"`
}Copy

// GetInfo 获取用户信息
func (r *userRepository) GetInfo(userId uint) (*models.UserInfo, error) {
    var ui models.UserInfo
    err := db.Preload("Icons").Preload("Icons.Asset").Where(&models.User{
        BaseModel: models.BaseModel{
            ID: userId,
        },
    }).First(&ui).Error
    return &ui, err
}

// GetIcons 获取用户头像
func (r *userRepository) GetIcons(userId uint) (*models.UserIcon, error) {
    var ui models.UserIcon
    err := db.Model(&ui).Preload("UserInfo").Where(&models.UserIcon{
        UserId: userId,
    }).First(&ui).Error
    return &ui, err
}Copy

ui, err := repositorie.UserRepository.GetInfo(1)
    if err != nil {
        panic(err)
    }
    utils.Println(ui)

    icons, _ := repositorie.UserRepository.GetIcons(1)
    if err != nil {
        panic(err)
    }
    utils.Println(icons)Copy

2022/04/15 09:49:18 E:/GoProject/nine/app/repositorie/user_repositorie.go:60
[2.150ms] [rows:1] SELECT `tz_asset`.`id`,`tz_asset`.`created_at`,`tz_asset`.`updated_at`,`tz_asset`.`deleted_at`,`tz_asset`.`name`,`tz_asset`.`file`,`tz_asset`.`extension` FROM `tz_asset` WHERE `tz_asset`.`id` = 1 AND `tz_as
set`.`deleted_at` IS NULL

2022/04/15 09:49:18 E:/GoProject/nine/app/repositorie/user_repositorie.go:60
[5.056ms] [rows:1] SELECT `tz_user_icon`.`id`,`tz_user_icon`.`created_at`,`tz_user_icon`.`updated_at`,`tz_user_icon`.`deleted_at`,`tz_user_icon`.`user_id`,`tz_user_icon`.`asset_id`,`tz_user_icon`.`is_activity` FROM `tz_user_i
con` WHERE `tz_user_icon`.`user_id` = 1 AND `tz_user_icon`.`deleted_at` IS NULL

2022/04/15 09:49:18 E:/GoProject/nine/app/repositorie/user_repositorie.go:60
[9.325ms] [rows:1] SELECT `tz_user`.`id`,`tz_user`.`email`,`tz_user`.`nickname`,`tz_user`.`profile` FROM `tz_user` WHERE `tz_user`.`id` = 1 ORDER BY `tz_user`.`id` LIMIT 1
{
    "id": 1,
    "email": "937681139@qq.com",
    "nickname": "任小兔",
    "profile": "",
    "icons": [
        {
            "id": 1,
            "created_at": "2022-04-15 09:46:36",
            "updated_at": "2022-04-15 09:46:38",
            "deleted_at": null,
            "user_id": 1,
            "asset_id": 1,
            "is_activity": 1,
            "asset": {
                "id": 1,
                "created_at": "2022-04-15 09:46:29",
                "updated_at": "2022-04-15 09:46:32",
                "deleted_at": null,
                "name": "test",
                "file": "01",
                "extension": "txt"
            },
            "user_info": null
        }
    ]
}

2022/04/15 09:49:18 E:/GoProject/nine/app/repositorie/user_repositorie.go:69
[2.156ms] [rows:1] SELECT `tz_user`.`id`,`tz_user`.`email`,`tz_user`.`nickname`,`tz_user`.`profile` FROM `tz_user` WHERE `tz_user`.`id` = 1

2022/04/15 09:49:18 E:/GoProject/nine/app/repositorie/user_repositorie.go:69
[4.969ms] [rows:1] SELECT `tz_user_icon`.`id`,`tz_user_icon`.`created_at`,`tz_user_icon`.`updated_at`,`tz_user_icon`.`deleted_at`,`tz_user_icon`.`user_id`,`tz_user_icon`.`asset_id`,`tz_user_icon`.`is_activity` FROM `tz_user_i
con` WHERE `tz_user_icon`.`user_id` = 1 AND `tz_user_icon`.`deleted_at` IS NULL ORDER BY `tz_user_icon`.`id` LIMIT 1
{
    "id": 1,
    "created_at": "2022-04-15 09:46:36",
    "updated_at": "2022-04-15 09:46:38",
    "deleted_at": null,
    "user_id": 1,
    "asset_id": 1,
    "is_activity": 1,
    "asset": {
        "id": 0,
        "created_at": null,
        "updated_at": null,
        "deleted_at": null,
        "name": "",
        "file": "",
        "extension": ""
    },
    "user_info": {
        "id": 1,
        "email": "937681139@qq.com",
        "nickname": "任小兔",
        "profile": "",
        "icons": null
    }
}
Copy