How to make approval system according to role hierarchy

I want to build an approval system like this

Example:- I have roles like Sr. Manager, Manager, Team Leader, Employees.

If employee raised a query, then this query will go to his team leader, he can approval/reject this query, if accept then this query will go to manager and Sr. Manager.

How to make a flow system like this.

Notification will also be sent.

I don't know how to setup make database table for this case.

Any help will be appreciated.

Thanks in advance.