The invention relates to concrete aggregate prepared by utilizing coal gangue and a preparation method thereof. The concrete aggregate is prepared from the following raw materials in parts by weight: 110-150 parts of broken coal gangue, 50-70 parts of foundry waste sand, 10-20 parts of copper sludge, 10-20 parts of red mud, 50-70 parts of regenerated diatomite broken pieces, 5-9 parts of additives, 6-10 parts of calcium hydroxide and 5-9 parts of sodium hydroxide solution with the mass concentration of 0.5mol/L, wherein the regenerated diatomite broken pieces are prepared from the following components in parts by weight: 40-60 parts of waste diatomite slurry, 20-30 parts of modified steel slag micro-powder, 6-11 parts of a surface modifier and 0.04-0.06 part of a foaming agent; and the modified steel slag micro-powder is prepared from steel slag and sodium metaborate which accounts for 1/10 to 1/2 of the weight of the steel slag. According to the invention, a large-scale application direction is found for the coal gangue, foundry waste sand, copper sludge, red mud, steel slag and waste diatomite, the waste materials are changed into things of value, and the environmental pollution and land occupation caused by solid wastes are reduced, so that the resources are further utilized, and energy conservation and environment friendliness are achieved.