Putting the data in the entire column in the database into an array using typescirpt and angular?

There is a table called Users and there are roles such as admin, user, customer. Each user can be assigned a role. I keep these roles in database. With Typescript, I want to pull all this role information as a roleId and throw it into an array. How can it be done?