Go语言中如何将MySQL查询结果List转换为自定义结构体切片？

package main

import (
    "encoding/json"
    "fmt"
)

func main() {
    // 模拟数据库查询结果，实际应用中需替换为数据库查询代码
    rss := []string{
        `{"id":1,"username":"xx","age":"xx","frist_name":"a"}`,
        `{"id":2,"username":"xx","age":"xx","frist_name":"b"}`,
        `{"id":3,"username":"xx","age":"xx","frist_name":"a"}`,
    }

    type r struct {
        Id        uint64 `json:"id"`
        Username  string `json:"username"`
        Age       string `json:"age"`
        FristName string `json:"frist_name"`
    }

    type UserLists struct {
        Id       uint64 `json:"id"`
        Username string `json:"username"`
        Age      string `json:"age"`
    }

    type myLists struct {
        FristName string      `json:"frist_name"`
        Lists     []UserLists `json:"lists"`
    }

    var resp []myLists

    // 使用map进行分组，提高效率
    firstNameMap := make(map[string][]UserLists)
    for _, rs := range rss {
        var t r
        err := json.Unmarshal([]byte(rs), &t)
        if err != nil {
            fmt.Println("Unmarshal error:", err)
            return
        }
        tul := UserLists{Id: t.Id, Username: t.Username, Age: t.Age}
        firstNameMap[t.FristName] = append(firstNameMap[t.FristName], tul)
    }

    for firstName, userList := range firstNameMap {
        resp = append(resp, myLists{FristName: firstName, Lists: userList})
    }

    // 将结果转换为JSON格式输出
    jsonData, err := json.MarshalIndent(resp, "", "  ")
    if err != nil {
        fmt.Println("Marshal error:", err)
        return
    }
    fmt.Println(string(jsonData))
}