typeorm find relation inside other relation

I have tables in postgresql:

users
id | username

chat_users
id | user_id | role

chat_messages
id | chat_user_id | message


I need to select 10 rows from chat_messages table with columns username role message. How to append relation in relation?

My current relations.

models/ChatMessage.ts

import { Entity, PrimaryGeneratedColumn, Column, ManyToOne, JoinColumn } from 'typeorm';
import { ChatUser } from './ChatUser';

@Entity({
name: 'chat_messages',
})
export class ChatMessage {
@PrimaryGeneratedColumn()
public id: number;

@ManyToOne((type) => ChatUser, (chatUser) => null)
@JoinColumn({ name: 'chat_user_id' })
public chatUser: ChatUser;

@Column({
type: 'text',
name: 'message',
})
public message: string;
}


models/ChatUser.ts

import { Entity, PrimaryGeneratedColumn, Column, ManyToOne, JoinColumn } from 'typeorm';
import { User } from './User';

@Entity({
name: 'chat_users',
})
export class ChatUser {
@PrimaryGeneratedColumn()
public id: number;

@ManyToOne((type) => User, (user) => null)
@JoinColumn({ name: 'user_id' })
public user: User;

@Column({
type: 'text',
name: 'role',
})
public role: string;
}


models/User.ts

import { Entity, PrimaryGeneratedColumn, Column } from 'typeorm';

@Entity({
name: 'users',
})
export class User {
@PrimaryGeneratedColumn()
public id: number;

@Column({
type: 'text',
nullable: true,
})
public username: string;
}

Continue reading...