I have to tables, users and classes. I need to show the classes count of each user with user ID and i have to show those users as well .. with no classes. how to do it ..

you mean each user have different classes ???

you can use count function some thing like this

select count(users),count(classes),userid,username from etc table check that one this is only the sample code make your question more understandable...