SELECT * FROM verknuepfungen LEFT JOIN categories ON (verknuepfungen.category = categories.id) LEFT JOIN user ON (user.ID = verknuepfungen.user_id)