A member of the Comancheros outlaw motorcycle club was found dead by a friend under a bridge