There's an easier way and it's explained in this article: http://www.sqlservercentral.com/articles/T-SQL/63681/

This is an example that might not work because I have nothing to test on.

-- Daily Report

SELECT UserID,

SUM(CASE WHEN OrderStatusID = 2 THEN OrderCount END) As Status2Count,

SUM(CASE WHEN OrderStatusID = 3 THEN OrderCount END) As Status2Count,

SUM(CASE WHEN OrderStatusID = 4 THEN OrderCount END) As Status2Count,

SUM(CASE WHEN OrderStatusID = 8 THEN OrderCount END) As Status2Count,

FROM(

SELECT u.UserID,

o.OrderStatusID,

COUNT(*) OrderCount

FROM Users u

JOIN Orders o ON u.UserID = o.userID

WHERE OrderStatusID IN( 2, 3, 4, 8)

GROUP BY u.UserID, OrderStatusID

HAVING COUNT(*) > 0)x --This is a pre-aggregation to improve performance, but should be tested.

GROUP BY UserID

EDIT: I was evaluating wy word choice and easier might not be accurate when there's no practice on how to do it, but it's certainly more efficient and will come natural when you fully understand it.