frame query with joins using typeorm code example

Example: typeorm

npm install typeorm -g
typeorm init --name MyProject --database mysql