Laravel count Support Tickets from a user

I have this in the Dashboard Screenshot of the Dashboard

I want that it shows how many Tickets are open / closed / all

How do I do this with this Database?Screenshot from SELECT * FROM tickets

How do I do this that every user see his own open / closed and all tickets?

via Chebli Mohamed