Sword of Mana on the GBA is probably the closest, it's pretty good. It's a remake of the Game Boy game Seiken Densetsu, (Secret of Mana is Seiken Densetsu 2) which was released as Final Fantasy Adventure in North America. It's short though, you can breeze through it in a couple of hours.
Children of Mana on the DS is a dungeon crawler and is nowhere close to SoM.
Sword of Mana was actually developed by Brownie Brown, which consists of members of the original Seiken Densetsu team. I'm sure they could do something in the same style as Secret of Mana, maybe on the DS.








