Self Relating table -lookup and report

Well I should re frame, the current user need not be a manager. So referencing from my earlier example. If the current user is rid 1- the report outcome should have staff rid 1,2,4. 
The logic you suggest above will work only when a manager logs in and will fail for any other user.

OK, I now get the question clearly.

Here is a thought that is a bit converted but will probably work.

Create Sync table of your employee file in the same app and set the userid to be the Key field.  The userid field will come across in the sync probably in the form of an email address in text format. Sync across the userid and the manager's userid.

Create a formula text field for the userid in text format on the employee file 

ToText([Userid of Employee])

 and then use that in a relationship to pull down the managers userid and call in [Current Users Manager userid in text format].  Once again, it will be in text format, so make a formula user field called 
[Current Users Manager userid]
with a formula of 

ToUser([Current Users Manager userid in text format])

Now you can filter your report with

[manager userid]
is equal to the value in the field [Current Users Manager userid]

Let me try this approach and get back. Thank you for your response. appreciate the help