Introduction to Bourbaki structures, and their relation to category theory
When Bourbaki began, in the 1930s, there was no "category theory", for one thing. One of the issues the group was addressing was the lack of "modern" texts (not only in French), and various problems of rigor in some existing sources. With hindsight, their notion of "structure" was not a big success, and they themselves did not really use it in later volumes.
It wasn't a completely frivolous idea, insofar as one can observe the dynamics of interactions of "different" fundamental notions ("algebraic" and "topological", etc.) However, with hindsight, the Bourbaki group was naive about foundations and philosophy-of-mathematics, no matter their great strengths in mathematics per se. Even their attitude about analysis seems skewed. E.g., where's the PDE volume? :)
Leo Corry's book "Modern algebra and the rise of mathematical structures" includes a discussion of Bourbaki's "structures", and makes comparisons to both category theory and some other early competing notions.
But, among other conclusions, one can ignore Bourbaki's notion of "structure" in terms of the practice of mathematics, or even for reading Bourbaki (!).
Edit: also, I think we should distinguish "foundational" from "organizational" attempts/conceptions, although an approach can include both. It does not seem that set theory ever tried to provide organizational principles for mathematics, only foundational (and interesting questions of its own). In contrast, category theory has always been far more organizational than foundational (despite Lawvere's work, and many others more recently). To my perception, Bourbaki's "structures" had more an organizational than foundational intention, although, arguably, any "economy" of concepts should make foundational burdens lighter.
I have seen a bit of Bourbaki's structure definition. The Bourbaki group defines structure roughly as a collection of sets with functions and relations on them. They take as an example a topological space which is a set together with some subset of its power set. Bourbaki's structures are anything which can be defined in this manner, like groups, etc.
Category theory studies classes of objects and their morphisms. It tries to classify constructions based on abstract properties of morphisms and diagrams. For instance, in category we have a description of a product without ever using "elements", and this definition of a product applies to all categories; whether or not a product actually exists is another issue. Sometimes it does, and sometimes it doesn't.
Category theory does not give us an obvious way of constructing familiar structures like groups in the first place, although there is interesting mathematics behind how far one can go just with the concept of a category.
I suggest forgetting Bourbaki altogether unless (a) you need a specific result or (b) you are interested in historical treatments. Since Bourbaki covered much, what you should choose instead depends on what you want to learn. If you are interested in Category Theory, keep looking at Mac Lane or try Awodey's book.
On the other hand, if you are interested in analyzing mathematics from its models and structure, try model theory. It's a branch of logic that studies the types of models that can occur for a given set of axioms and how those models differ, both from a first-order perspective (i.e. what can you distinguish just by first-order sentences) and from an outside perspective (are they isomorphic?). David Marker's book on model theory is a nice introduction.
If you are just interested in specific structures like groups, rings, etc. read some abstract algebra. You should have a good familiarity with abstract algebra, which will help you understand why category theory is so important. Depending on how much algebra you know, picking up an introductory book like Rotman's on Homological Algebra might interest you. You can also look at Weibel's book on Homological Algebra, which is my favourite, although it is more advanced.
Most graduate algebra textbooks introduce some really basic category theory and use it in algebra. Jacobson's Basic Algebra 2 is pretty nice and includes various diagram definitions.