total count and recent data in one query?

Yes, it should be possible, but you need to show some code..

Here is an example:

User::with('posts')->withCount('posts')->get();

thank you for reply. In statistics page of my application I want to have a list of recent users and also I want to show total number of users. there are others things too like total number of orders and recent orders. you know general information. Im trying to reduce number of queries since I want to display data from multiple tables.

@danimohamadnejad not having any code on what you've tried, what do you have now and what you are trying to achieve as an end result, it is hard to give you an advice.

Writing one query of course it is possible, but the relationship has to be setup correctly between the tables and so on. But then again, show some code.

Take a look at this blog post for example:

https://laraveldaily.com/eloquent-withcount-get-related-records-amount/

honestly I dont have any code I am just figuring out how to write it. I dont want to get any relation data are toataly separate.

If you just follow the documentation and write the queries as the examples in the background the correct queries will take place.

And no it will not be just one query it will be at least two if you're pulling in relations also.

But eloquent takes care of that for you.