How to retrieve data from a table with two of the columns in the table with the same value?
You can use SELF JOIN to get result

select t1.* 
from my_table as t1
join my_table as t2 on t1.userid = t2.followinguserid