How to return one to many records on single query
This is fundamental to how relational databases operate, I'm not sure what to tell you, it's not magic. The docs describe some approaches, however, which you may check out: http://docs.peewee-orm.com/en/latest/peewee/relationships.html#avoiding-the-n-1-problem
I have users and tweets table, 1 user has many tweets, 1 tweet belongs to an user
```
class User(BaseModel):
    class Meta:
        db_table = 'users'
    uuid = UUIDField(primary_key=True)
    email = CharField()


class Tweet(BaseModel):
    class Meta:
        db_table = 'tweets'
    uuid = UUIDField(primary_key=True)
    content = TextField()
    user = ForeignKeyField(User, backref='tweets', related_name='tweets')
```

For get Tweet, it"s return with user, no problem

`tweets = (Tweet.select().join(User))
`
```
[
    {
        "uuid": "74dbadc6-7fa9-44cf-92cc-236f4605721f",
        "content": "meow",
        "user": {
            "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
            "email": "duc.nguyen@codecomplete.jp"
        }
    },
    {
        "uuid": "a4da5282-6f5f-4ad9-aec6-d8813ba1f2e8",
        "content": "hiss",
        "user": {
            "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
            "email": "duc.nguyen@codecomplete.jp"
        }
    },
    {
        "uuid": "556748ee-9ac8-4ed0-9dac-0b760ae4349b",
        "content": "purr",
        "user": {
            "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
            "email": "duc.nguyen@codecomplete.jp"
        }
    },
    {
        "uuid": "e8ba2c18-59ac-4968-98e0-e4ce58ee5094",
        "content": "woof",
        "user": {
            "uuid": "6835d471-acd9-46d4-b73c-c6ccab91d547",
            "email": "duc.nguyen1@codecomplete.jp"
        }
    },
    {
        "uuid": "7584c092-906d-41e3-84a0-ee6b8f3d88f9",
        "content": "whine",
        "user": {
            "uuid": "6835d471-acd9-46d4-b73c-c6ccab91d547",
            "email": "duc.nguyen1@codecomplete.jp"
        }
    }
]
```

but when I try to get all user with tweets, it"s not working
`users = User.select(User, Tweet).join(Tweet)
`
```
[
    {
        "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
        "email": "duc.nguyen@codecomplete.jp"
    },
    {
        "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
        "email": "duc.nguyen@codecomplete.jp"
    },
    {
        "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
        "email": "duc.nguyen@codecomplete.jp"
    },
    {
        "uuid": "6835d471-acd9-46d4-b73c-c6ccab91d547",
        "email": "duc.nguyen1@codecomplete.jp"
    },
    {
        "uuid": "6835d471-acd9-46d4-b73c-c6ccab91d547",
        "email": "duc.nguyen1@codecomplete.jp"
    }
]
```

my expect:
```
[
    {
        "uuid": "5bb50b91-c7da-4b25-8f9c-2ffb39d4235b",
        "email": "duc.nguyen@codecomplete.jp",
        "tweets": [
            {
                ...
            },
            {
                ...
            }
        ]
    },
    ....
]
```