Scan gorm join resulsts with nested objects

gorm-join.go

type Post struct {
	ID    int
	Title string
	Date  time.Time
}

type User struct {
	Name string
	Post Post
}

func query() {
	var users []User
	gorm.Table("users").
		Select("users.name, post.id, post.title").
		Joins(`LEFT JOIN posts AS post
				ON id = (
					SELECT id FROM posts WHERE user_id = id ORDER BY date DESC LIMIT 1
				)`).
		Scan(&users)
}