Trying to retrieve data from firebase where the category is equal to the string

The problem in your code lies in the fact that you are using an incorrect query:

databaseReference.child("Sports").orderByChild("category").equalTo("football"))

Assuming that MyStudents is a child right under your root node and the following statement:

if (Categories.InternetConnection.checkConnection(Categories.this)) { /* ... */ }

Returns true, please use the following query:

String uid = FirebaseAuth.getInstance().getCurrentUser().getUid();
DatabaseReference rootRef = FirebaseDatabase.getInstance().getReference();
DatabaseReference uidRef = rootRef.child(uid);
Query queryByCategory = uidRef.orderByChild("category").equalTo("Football");
queryByCategory.addValueEventListener(/* ... */);

Things to notice:

1. KihlyfLkJMQ5uZWBDgLWNuBHKAE2 is the UID of the logged-in user and should be added as a child in the reference.
2. The value of the category property is called "Football" and not "football", with lower-case "f".

Edit:

According to your last comment:

I'm not trying to just get their information I'm trying to get everyone that has students whose category is Football

There is no way you can achieve that using your actual database structure. The most simple solution I can think of is to create a new node that contains all Model_Information objects, no matter the user is. This practice is called denormalization and is a common practice when it comes to Firebase. For a better understanding, I recommend you see this video, Denormalization is normal with the Firebase Database.

Also, when you are duplicating data, there is one thing that needs to keep in mind. In the same way, you are adding data, you need to maintain it. In other words, if you want to update/delete an item, you need to do it in every place that it exists.

Here is the answer. Hopefully its helpful for someone :)

    databaseReference = FirebaseDatabase.getInstance().getReference().child("MyStudents");
        if (Categories.InternetConnection.checkConnection(Categories.this)) {
    
            databaseReference.addValueEventListener(new ValueEventListener() {
    
    
                @Override
                public void onDataChange(@NonNull DataSnapshot dataSnapshot) {
    
                        myUploads.clear();
    
                    for (DataSnapshot userSnapshot : dataSnapshot.getChildren()) {
                        for (DataSnapshot postsnapshot : userSnapshot.getChildren()) {
                            Model_Information upload = postsnapshot.getValue(Model_Information.class);
                         
                            Collections.shuffle(myUploads);
    
                                    if (upload.getCategory().equals("Football")) {
                                        myUploads.add(upload);
                                    }else{
                                       
   Toast.makeText(Categories.this, "No results", Toast.LENGTH_LONG).show();

    
                                    }
    
                                    recyclerView.invalidate();
                                }
                          
                            myUploads.add(upload);
                            recyclerView.invalidate();
                        }
                    }
                        
    
                        aAdapter.notifyDataSetChanged();
    
                }
    
                @Override
                public void onCancelled(@NonNull DatabaseError databaseError) {
                    Toast.makeText(Categories.this, databaseError.getMessage(), Toast.LENGTH_LONG).show();
    
                }
            });