LEFT OUTER JOIN basically states "If there is a campaign with uID equal to user.id, JOIN it in the row, otherwise put all fields to NULL". Since this is optional, in the grand scheme of things you can neglect it, and your query boils down to
SELECT COUNT(*) as total
FROM (users INNER JOIN users as guides ON guides.uid = users.guide)
WHERE users.guide = 110;
Which will indeed get you the number of guides for a user.
What are you trying to achieve?