SQL - joining twice same table

[iznogud999]

hi there! this is driving me crazy today!
Here's what I have:

CREATE TABLE married (
id_married int(11) NOT NULL auto_increment,
id_he int(11) NOT NULL default '0',
id_she int(11) NOT NULL default '0',
PRIMARY KEY (id_married)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO married VALUES (1, 1, 3);
INSERT INTO married VALUES (2, 2, 4);

____________________--------------------------___________

CREATE TABLE users (
id_user int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
lastname varchar(255) NOT NULL default '',
PRIMARY KEY (id_user)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

INSERT INTO users VALUES (1, 'Mary', 'Poppins');
INSERT INTO users VALUES (2, 'Ann', 'Popper');
INSERT INTO users VALUES (3, 'Jack', 'Borton');
INSERT INTO users VALUES (4, 'Luke', 'Skywalker');

How can I build my query in order to have something like this?:
id_married | his_name | his_surname | her_name | her_surname

It looks like i have to join table users twice once to get name and surname for him and another time to get name and surname for her. But I've been spending hours without getting results. Please help me if you can. Even a link, a hint would be nice. Thanks in advance

[Piranha]

SELECT married.id_married, his.name, his.lastname, her.name, her.lastname
FROM married
LEFT JOIN users him // Makes this users table called "him" in the rest of the query
ON married.id_he = him.id_user
LEFT JOIN users her // Makes this users table called "her" in the rest of the query
ON married.id_she = her.id_user

Just note that it is possibel in some places that two men marry each other or that two women marry each other. If you decide that a person can only be married to one other then a betterway to do all this would be the following:

table married
id_married int auto_increment
// Other data, but not him and her

table user
id_user auto_increment
married_id references married(id_married)
// Other data